/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 vote113 views1 answer
Expose db in virtualbox
SQL
3 votes162 views2 answers
Having in mysql
SQL
2 votes159 views2 answers
Create empty table from existing table
SQL
0 vote151 views1 answer
Sql server remove enter from string
SQL
20 votes160 views6 answers
Change password in mysql
SQL
0 vote174 views1 answer
How to print sql query
SQL
3 votes151 views2 answers
Mysql config user password
SQL
0 vote174 views1 answer
Unique element in sql
SQL
0 vote159 views1 answer
Datagrip exec
SQL
17 votes172 views2 answers
Mysql date to string
SQL