/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 vote226 views1 answer
Sql select sum group by id laravel
SQL
0 vote275 views1 answer
Example database query
SQL
0 vote276 views1 answer
Run mysql xampp shell
SQL
0 vote225 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
12 votes183 views2 answers
Select into insert sql server
SQL
0 vote191 views1 answer
Sql query to get column names and data types in sql server
SQL
1 vote193 views2 answers
Mysql error 1215
SQL
0 vote172 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
2 votes211 views1 answer
Sql update \
SQL
0 vote183 views1 answer
Why we have to set the password for my sql server
SQL