/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 vote196 views1 answer
Change filed order in mysql
SQL
0 vote185 views1 answer
Get role postgres
SQL
0 vote184 views1 answer
Dapper run sql script with parameters
SQL
0 vote190 views1 answer
Modifier une valeur sql
SQL
1 vote181 views1 answer
Loading local data is disabled mysql
SQL
0 vote205 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
0 vote215 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
1 vote190 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
0 vote182 views1 answer
Python connect microsoft sql server
SQL
0 vote171 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL