/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 vote231 views1 answer
Get month and year from date in mysql sequelize
SQL
33 votes158 views6 answers
Change column name in mysql
SQL
6 votes153 views1 answer
Oracle trigger after connect
SQL
12 votes163 views6 answers
Select distinct
SQL
0 vote163 views1 answer
Psql show db
SQL
13 votes153 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote161 views1 answer
Get cpu details sql
SQL
0 vote143 views1 answer
How to change null display in psql
SQL
3 votes158 views1 answer
Get current month last date in sql server
SQL
3 votes222 views1 answer
Mysql group_concat distinct
SQL