/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

6 votes169 views1 answer
Oracle list primary key
SQL
0 vote186 views1 answer
Sql revert migration
SQL
0 vote204 views1 answer
How to add mysql to path on termin after installation
SQL
1 vote172 views1 answer
Oracle db create new schema
SQL
1 vote172 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
21 votes168 views3 answers
Sql average
SQL
1 vote179 views1 answer
Postgres start database on linux
SQL
1 vote170 views1 answer
Oracle get current schema
SQL
1 vote174 views1 answer
Sql server datetime vs datetime2
SQL
0 vote325 views1 answer
Hue hive UploadingTextFiletoHive
SQL