/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

11 votes281 views2 answers
Turn off safe mode mysql
SQL
0 vote281 views1 answer
Search column name sql
SQL
-2 votes282 views4 answers
How to get max salary in each department in sql
SQL
0 vote284 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
0 vote229 views1 answer
Ms sql print more than 1 variable
SQL
1 vote267 views1 answer
Sql server find tables referenced foreign key
SQL
0 vote284 views1 answer
Mysql grant grant option
SQL
4 votes281 views1 answer
Is there any command to change postgres password
SQL
2 votes298 views1 answer
Mysql increment value by 1 in update
SQL
0 vote259 views1 answer
Como verificar registros duplicados no sql postgresql
SQL