Answers for "postgres 12 get user privileges"

Whatever

1

grant read only privileges postgres user

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";

Posted by: Guest on November-12-2020

Code answers related to "postgres 12 get user privileges"

Code answers related to "Whatever"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#