/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

1 vote218 views1 answer
Increase date by one day in sql oracle
SQL
2 votes146 views1 answer
Sql group by different columns
SQL
0 vote213 views1 answer
How convert into in in sql query
SQL
4 votes192 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote205 views1 answer
Php select data from mysql database without column name
SQL
0 vote205 views1 answer
Horizontal join sqlite
SQL
0 vote145 views1 answer
Microsoft sql server management studio clear cache
SQL
2 votes215 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
5 votes184 views1 answer
JBDC
SQL
0 vote192 views1 answer
Alasql delete column
SQL