📋Steps in this guide1/1

Find privileges granted to a user postgres

-- List down table level privileges of user SELECT table_catalog, table_schema, table_name, privilege_type FROM information_schema.table_privileges WHERE grantee = 'USER_NAME';

postgresql configurationintermediate

by PostgreSQL

13 views

Find privileges granted to a user postgres

-- List down table level privileges of user SELECT table_catalog, table_schema, table_name, privilege_type FROM information_schema.table_privileges WHERE grantee = 'USER_NAME'; -- List down usage privileges of a user:

Code/Command (click line numbers to comment):

select * from usage_privileges where grantee='USER_NAME';

Comments (0)

Please to add comments

No comments yet. Be the first to comment!