Tuesday, April 14, 2015

PostgreSQL Query Grants


SELECT grantee, privilege_type
FROM information_schema.role_table_grants
WHERE table_name='thetable';

Reference: http://stackoverflow.com/questions/7336413/query-grants-for-a-table-in-postgres

No comments:

Post a Comment