/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

0 vote108 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL
6 votes139 views5 answers
Oracle list tablespaces
SQL
0 vote102 views1 answer
How to export table data from mysql table in sql format
SQL
0 vote128 views2 answers
Plpgsql
SQL
0 vote88 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote108 views1 answer
Install sql server windows 10
SQL
0 vote144 views3 answers
Mysql CAST(amount as float)
SQL
0 vote103 views1 answer
Mysql docker image for macbook m1
SQL
0 vote108 views1 answer
Oracle execute immediate quotes
SQL
4 votes97 views1 answer
Oracle table statistics last analyzed
SQL