/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

0 vote301 views1 answer
Postgres grep entire database
SQL
0 vote281 views1 answer
Get week day name sql server
SQL
19 votes299 views5 answers
Date between in mysql
SQL
5 votes287 views2 answers
Postgre insert select
SQL
10 votes287 views1 answer
Oracle all_dependencies
SQL
3 votes293 views2 answers
Mysql create database
SQL
0 vote298 views1 answer
Delete data from database sqlite android
SQL
7 votes272 views4 answers
How to reset the identity column in sql server
SQL
2 votes308 views1 answer
Postgresql update sequence next value
SQL
7 votes285 views1 answer
Alter sequence set current value oracle
SQL