/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 vote212 views1 answer
Sqlalchemy existing database
SQL
0 vote270 views1 answer
Get yesterday date ISO in psql
SQL
0 vote282 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote273 views1 answer
If column value is null then in mysql
SQL
0 vote266 views1 answer
Postgresql delete multiple rows
SQL
11 votes265 views1 answer
Ddl materialized view
SQL
0 vote262 views1 answer
H2 auto increment and unique
SQL
0 vote264 views1 answer
Mysql use password error
SQL
0 vote270 views1 answer
Oracle show running job
SQL
0 vote276 views1 answer
Oracle sql number to varchar2
SQL