Skip to content

Instantly share code, notes, and snippets.

@graphbear

graphbear/table_grants.sql

Created May 1, 2017 20:07
Show Gist options
  • Save graphbear/62b52585f9284cd375712e4b52255619 to your computer and use it in GitHub Desktop.
Save graphbear/62b52585f9284cd375712e4b52255619 to your computer and use it in GitHub Desktop.
Download ZIP
table grants
Raw
table_grants.sql
-- http://stackoverflow.com/questions/7336413/query-grants-for-a-table-in-postgres
SELECT grantee, privilege_type
FROM information_schema.role_table_grants
WHERE table_name='mytable'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment