/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

1 vote136 views1 answer
Oracle undo usage per session
SQL
0 vote146 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote101 views1 answer
Get last run query sql server
SQL
0 vote143 views1 answer
Comparing with today and yesterday record in sql query
SQL
0 vote145 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
6 votes157 views2 answers
Postgresql pg_dump
SQL
3 votes131 views1 answer
Postgresql if null then 0
SQL
0 vote150 views1 answer
Limit in access query
SQL
3 votes143 views1 answer
Postgresql db owner change
SQL
0 vote109 views1 answer
Query for maximum salary
SQL