/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 vote367 views1 answer
Oracle concat datetime
SQL
0 vote326 views1 answer
Install package for sqlserver in asp.net core
SQL
0 vote345 views1 answer
Drush run sql select
SQL
4 votes340 views2 answers
How to insert ip address in mysql using php
SQL
0 vote337 views1 answer
Windows services sql
SQL
0 vote337 views1 answer
How to find username and password in oracle 18c
SQL
7 votes364 views2 answers
Mysql check db size
SQL
23 votes328 views6 answers
Delete all rows from table sql
SQL
0 vote329 views1 answer
Oracle drop default value
SQL
0 vote352 views1 answer
How to run mysql in git bash
SQL