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
Post a Comment