Thread: user privileges for particular table

user privileges for particular table

From
"Thomas T. Thai"
Date:
how can you show a user's privileges for a particular table of a
particular db?

select * from pg_user; doesn't do it


Re: user privileges for particular table

From
Tom Lane
Date:
"Thomas T. Thai" <tom@minnesota.com> writes:
> how can you show a user's privileges for a particular table of a
> particular db?

The info is in the relacl column of pg_class's row for that table.  You
might also have to look at pg_group to determine whether the user is a
member of any groups that are granted privileges on the table.

            regards, tom lane