/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

19 votes195 views1 answer
Sqrt(-1)
SQL
-1 vote314 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
0 vote231 views1 answer
How to select a row in sql
SQL
3 votes229 views1 answer
Oracle apex call duration
SQL
0 vote219 views1 answer
Mysql find db contarint
SQL
0 vote224 views1 answer
Mysql server not running
SQL
0 vote259 views1 answer
Parent and child link in mysql
SQL
4 votes257 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote265 views1 answer
For select oracle
SQL
0 vote228 views1 answer
Sql recherche nom prenom
SQL