/SQL/Command to give readonly access to a postgres sql user

Command to give readonly access to a postgres sql user

sudo -u postgres psql
CREATE USER username WITH PASSWORD 'your_password';
GRANT CONNECT ON DATABASE database_name TO username;
GRANT USAGE ON SCHEMA schema_name TO username;
GRANT SELECT ON ALL TABLES IN SCHEMA schema_name TO username;
ALTER DEFAULT PRIVILEGES IN SCHEMA schema_name
GRANT SELECT ON TABLES TO username;

Source: tableplus.com

Similar codes

0 vote180 views1 answer
How to find sql server installation folder
SQL
0 vote168 views1 answer
Update table sql multiple set
SQL
36 votes173 views3 answers
Finding duplicate column values in table with sql
SQL
0 vote169 views1 answer
Sql track modification
SQL
1 vote167 views1 answer
Sql select contem uma palavra
SQL
0 vote168 views1 answer
Mysql add to value
SQL
0 vote174 views3 answers
Convert sql query to python pandas
SQL
0 vote168 views1 answer
Oracle query to see what scema i am working in
SQL
0 vote211 views1 answer
Python dictionary to sql update
SQL
0 vote168 views1 answer
First Step in installing SQL workbench
SQL