Postgres: What tables and privileges user have access to



SELECT distinct information_schema.role_table_grants.grantee, information_schema.role_table_grants.privilege_type, information_schema.table_privileges.table_name
FROM information_schema.role_table_grants, information_schema.table_privileges
WHERE information_schema.role_table_grants.grantee = 'eisuser'
and information_schema.role_table_grants.grantee=information_schema.table_privileges.grantee;

Comments

Popular posts from this blog

Postgres: Clean up stopped replication slot

PeopleSoft: Clean Up PUM