/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 vote193 views1 answer
Increase existing date in sql
SQL
4 votes173 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote211 views10 answers
Sql statement checker corrector
SQL
0 vote186 views1 answer
Sql alchemy escape ; in insert statement
SQL
15 votes179 views4 answers
Sql update from select
SQL
0 vote184 views1 answer
Convert rows to columns in sql server
SQL
2 votes174 views1 answer
Sql create database
SQL
1 vote182 views1 answer
Copy postgres table from one schema into another
SQL
2 votes184 views1 answer
Postgresql change value in column
SQL
0 vote142 views1 answer
Print sum of values sql
SQL