/SQL/Postgres grant read only access to database

Postgres grant read only access to database

grant connect on database "mydatabase" to "user";
GRANT USAGE ON SCHEMA public TO "user";
GRANT SELECT ON ALL TABLES IN SCHEMA "public" TO "user";
ALTER DEFAULT PRIVILEGES IN SCHEMA "public"
   GRANT SELECT ON TABLES TO "user";

Source: grepper.com

Similar codes

6 votes198 views2 answers
Oracle undotbs usage
SQL
1 vote188 views1 answer
Give a column name to values generated from case statement in sql
SQL
0 vote192 views2 answers
How to find max and min salary in sql
SQL
2 votes187 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote182 views2 answers
Mysql updating multiple column values from array variable
SQL
1 vote198 views1 answer
Nullif postgresql
SQL
0 vote197 views1 answer
Power bi union columns
SQL
2 votes208 views1 answer
Column names in oracle sql
SQL
0 vote178 views1 answer
Oracle synonym procedure
SQL
0 vote206 views1 answer
Including parameters in OPENQUERY
SQL