/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

7 votes143 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
0 vote142 views1 answer
Drop constraint in ms sql
SQL
0 vote138 views1 answer
Create a table from one field of another table
SQL
0 vote142 views1 answer
Create table sql generator
SQL
0 vote209 views2 answers
Wordpress change url in database
SQL
0 vote163 views2 answers
Create-toys-table-with-toy_name-column
SQL
7 votes136 views2 answers
Show size database mysql
SQL
1 vote138 views1 answer
Wherein mysql
SQL
0 vote135 views1 answer
Mql5 list all available symbols
SQL
0 vote200 views1 answer
Postgres dump sql insert
SQL