/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 vote391 views1 answer
How to check all scheduled jobs in oracle
SQL
0 vote323 views1 answer
Bigquery declare
SQL
-1 vote384 views4 answers
Full outer join in sql
SQL
7 votes341 views1 answer
Sql limit decimal places
SQL
0 vote320 views2 answers
Mysql multiply
SQL
7 votes321 views1 answer
Sql management studio display line numbers
SQL
0 vote345 views1 answer
How to make full text search dynamic in mysql
SQL
3 votes340 views2 answers
Mysql user permission database
SQL
1 vote321 views1 answer
Oracle sql assign unique number to each grouping
SQL
0 vote324 views1 answer
Sql fetch next 10 rows pdo
SQL