/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 vote156 views1 answer
Key validation sql
SQL
0 vote137 views1 answer
Mysql count grouped rows
SQL
0 vote154 views1 answer
Pl/pgsql declare variable
SQL
0 vote142 views1 answer
Mysql query with sql to get the next row
SQL
0 vote136 views1 answer
Top frequency in sql server
SQL
0 vote140 views1 answer
Sql select by content lenght
SQL
1 vote140 views2 answers
Pad zero sql server
SQL
0 vote171 views1 answer
Copy row from db to db mysql
SQL
0 vote143 views1 answer
Power query datetime to date
SQL
0 vote131 views1 answer
Sql server split string and insert into table select
SQL