/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 vote234 views1 answer
Oracle apex prevent initial load
SQL
0 vote241 views1 answer
Sql server sleep
SQL
2 votes250 views2 answers
Sql percentage
SQL
0 vote236 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
12 votes233 views1 answer
Docker mysql random root password
SQL
21 votes253 views1 answer
Cheatsheet for sql
SQL
0 vote224 views1 answer
Oracle execute package dblink
SQL
10 votes236 views3 answers
Join multiple tables sql
SQL
0 vote236 views1 answer
Enable full text search mysql
SQL
0 vote250 views1 answer
Kill a pid redshift
SQL