/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 votes255 views1 answer
Oracle list grants on procedure
SQL
0 vote270 views1 answer
Alter rename command in mysql
SQL
0 vote241 views1 answer
Parsing float to int in mysql
SQL
3 votes269 views1 answer
Sql is not like
SQL
1 vote243 views2 answers
How to drop a unique constraint in sql
SQL
0 vote273 views1 answer
OFFSET consulta mysql
SQL
2 votes255 views2 answers
How to get capital letter first in sql
SQL
-1 vote312 views4 answers
Full outer join in sql
SQL
3 votes254 views1 answer
Oracle rollback
SQL
4 votes255 views4 answers
Sqlite describe table
SQL