Answers for "grant permission to postgres user"

7

grant all privileges database postgres to user

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA schema_name TO username;
Posted by: Guest on May-20-2020
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
0

grant all privileges database postgres to user

GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA schema_name TO username;
Posted by: Guest on May-20-2020

Code answers related to "grant permission to postgres user"

Browse Popular Code Answers by Language