Re: How to list a role's permissions for a given relation?

Thanks!

kynn

On Tue, Oct 27, 2009 at 4:02 PM, Richard Huxton <dev(at)archonet(dot)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
>