/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

20 votes364 views6 answers
Change password in mysql
SQL
1 vote316 views1 answer
Mysql show data from table
SQL
1 vote310 views1 answer
How to delete record sql delphi
SQL
1 vote333 views1 answer
How to between in sql
SQL
0 vote333 views1 answer
Group_concat only returns one row
SQL
0 vote339 views1 answer
Search starting with mysql
SQL
2 votes324 views1 answer
Oracle index size calculation
SQL
0 vote342 views1 answer
Import sql inside hide sql
SQL
7 votes341 views2 answers
Add column table pl sql
SQL
35 votes341 views6 answers
Postgres
SQL