/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

2 votes304 views2 answers
Mysql show table column comments sql
SQL
0 vote315 views1 answer
Find usage of table in sql server
SQL
11 votes312 views2 answers
Insert current date sql
SQL
0 vote333 views1 answer
Sqlite unique multiple columns
SQL
2 votes283 views1 answer
Plsql left() function
SQL
0 vote320 views2 answers
Functions with parameters SQL
SQL
0 vote315 views1 answer
Count database access django
SQL
2 votes299 views1 answer
Oracle trace session
SQL
0 vote297 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
5 votes296 views1 answer
Pl sql asynchronous procedure calls
SQL