Answers for "view users permissions on a single database postgresql"

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

grant permission in postgres

GRANT ALL PRIVILEGES ON DATABASE db_name TO username;

Posted by: Guest on October-31-2021

Code answers related to "view users permissions on a single database postgresql"