/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

1 vote142 views1 answer
Mysql tables max count
SQL
0 vote114 views1 answer
How to subquey to do not load in live database in
SQL
2 votes108 views1 answer
Import large .sql files into lampp
SQL
-1 vote109 views1 answer
Default username and password for oracle 11g
SQL
3 votes118 views3 answers
1396(hy00) mysql error
SQL
0 vote106 views1 answer
Convert excel into sqllite db using python
SQL
16 votes116 views2 answers
Sql vs nosql
SQL
1 vote109 views2 answers
Snowflake alter column data type
SQL
0 vote111 views1 answer
Mysql Digital Ocean connection problems
SQL
31 votes101 views1 answer
Postgresql add column with constraint
SQL