Thanks! kynn
On Tue, Oct 27, 2009 at 4:02 PM, Richard Huxton <d...@archonet.com> wrote: > 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 >
