/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 vote361 views1 answer
Sql script get all stored procedures from database
SQL
1 vote403 views1 answer
How to put value in variable mysql
SQL
0 vote314 views1 answer
Split a string with expression and get the last value of split sql
SQL
15 votes327 views2 answers
How to know the username of postgresql
SQL
2 votes391 views1 answer
Oracle insert or update
SQL
10 votes364 views3 answers
Join multiple tables sql
SQL
1 vote378 views1 answer
Mysql text to decimal
SQL
0 vote359 views1 answer
Multiple replace value mssql
SQL
3 votes494 views9 answers
Linq to sql converter online
SQL
1 vote359 views1 answer
Join first name and last name sql
SQL