/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

2 votes78 views1 answer
Foreign key example in dbms
SQL
2 votes121 views1 answer
Postgresql format date dd/mm/yyyy
SQL
0 vote120 views1 answer
Sql get user account
SQL
0 vote121 views1 answer
Rails sql query converstion
SQL
18 votes125 views6 answers
Drop table if exists
SQL
1 vote121 views1 answer
Return size of tables in mysql
SQL
7 votes121 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
0 vote117 views1 answer
Sql server convert date to weekday
SQL
0 vote120 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
-1 vote128 views1 answer
Su: Authentication failure mysql
SQL