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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
