Thread: How to list a role's permissions for a given relation?
How can I list the permissions of a given user/role for a specific relation/view/index, etc.?
Thanks!
Kynn
Kynn Jones wrote: > How can I list the permissions of a given user/role for a specific > relation/view/index, etc.? From psql use \dp <tablename> Using plain SQL, the closest I can think of are the has_xxx_privilege() functions: http://www.postgresql.org/docs/8.4/static/functions-info.html There is also the standard information_schema views: http://www.postgresql.org/docs/8.4/static/information-schema.html e.g. table_privileges, column_privileges Finally, there are the system-catalogues themselves: http://www.postgresql.org/docs/8.4/static/catalogs.html Look in pg_class for relacl - an array of table (and index) permissions. Similarly pg_proc has proacl for functions. -- Richard Huxton Archonet Ltd
Thanks!
kynn
On Tue, Oct 27, 2009 at 4:02 PM, Richard Huxton <dev@archonet.com> wrote:
Kynn Jones wrote:From psql use \dp <tablename>
> How can I list the permissions of a given user/role for a specific
> relation/view/index, etc.?
Using plain SQL, the closest I can think of are the has_xxx_privilege()
functions:
http://www.postgresql.org/docs/8.4/static/functions-info.html
There is also the standard information_schema views:
http://www.postgresql.org/docs/8.4/static/information-schema.html
e.g. table_privileges, column_privileges
Finally, there are the system-catalogues themselves:
http://www.postgresql.org/docs/8.4/static/catalogs.html
Look in pg_class for relacl - an array of table (and index) permissions.
Similarly pg_proc has proacl for functions.
--
Richard Huxton
Archonet Ltd