user privileges for particular table
Started by Thomas T. Thaiover 25 years ago2 messagesgeneral
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
"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