/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

10 votes335 views4 answers
Else if mysql
SQL
3 votes326 views2 answers
How to open postgresql in windows
SQL
1 vote311 views2 answers
Mysql select tables with name like
SQL
1 vote292 views2 answers
T-sql random number for each row
SQL
4 votes304 views2 answers
Insert current date in mysql
SQL
0 vote318 views4 answers
Mysql count table rows
SQL
17 votes339 views4 answers
Show tables sql server
SQL
0 vote283 views1 answer
Postgresql parse json array
SQL
0 vote317 views1 answer
Ubuntu connect to mssql database
SQL
1 vote299 views2 answers
End mysql command
SQL