Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

list all permissions on a table in postgres

SELECT grantee, privilege_type 
FROM information_schema.role_table_grants 
WHERE table_name='mytable'
Source by dba.stackexchange.com #
 
PREVIOUS NEXT
Tagged: #list #permissions #table #postgres
ADD COMMENT
Topic
Name
3+2 =