Обсуждение: user privileges for particular table

Поиск
Список
Период
Сортировка

user privileges for particular table

От
"Thomas T. Thai"
Дата:
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

От
Tom Lane
Дата:
"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