Answers for "grant read permissions postgres"

SQL
0

list all permissions on a table in postgres

SELECT grantee, privilege_type 
FROM information_schema.role_table_grants 
WHERE table_name='mytable'
Posted by: Guest on April-06-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

Code answers related to "grant read permissions postgres"

Code answers related to "SQL"

Browse Popular Code Answers by Language