/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 vote213 views1 answer
Sql value exists in column
SQL
1 vote215 views1 answer
Best sql course
SQL
2 votes210 views2 answers
Mamp connect mysql terminal
SQL
2 votes238 views1 answer
Search query in mysql
SQL
11 votes211 views2 answers
MySQL DISTINCT
SQL
0 vote263 views1 answer
Pl sql join 3 tables
SQL
1 vote218 views1 answer
How to between in sql
SQL
-1 vote234 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote225 views1 answer
Which lock mode is not available in sql
SQL
0 vote226 views1 answer
Will graphql replace sql
SQL