Postgres: To see every table a specific user has been granted access to
SELECT grantee, privilege_type, table_name
FROM information_schema.role_table_grants
WHERE grantee = 'YOUR_USER_NAME';
-- WHERE grantee = 'edduser'
-- order by table_name;
Postgres: To list table owners
SELECT schemaname, tablename, tableowner FROM pg_tables WHERE schemaname NOT IN ('pg_catalog', 'information_schema') ORDER BY tableowner, schemaname, tablename;
Comments
Post a Comment