/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 vote115 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
4 votes122 views2 answers
How to count items with same name in sql
SQL
5 votes118 views2 answers
Oracle to_timestamp
SQL
1 vote115 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
0 vote128 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
0 vote114 views1 answer
Selecting Data in SQL - Select Data
SQL
0 vote120 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
3 votes125 views2 answers
Oracle sql drop sequence
SQL
0 vote139 views1 answer
Postgresql cast as year and month from timestamp
SQL
4 votes132 views1 answer
Mysql biginteger size
SQL