Re: Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C207B2C09F@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответ на Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.  (leaf_yxj <leaf_yxj@163.com>)
Ответы Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.  (leaf_yxj <leaf_yxj@163.com>)
Re: Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
leaf_yxj wrote:
> My bosses ask me  to list all the users and all the privilege which
the superuser granted  to the
> users.
> Then they can double check that I did right thing or not?

Unlike Oracle, PostgreSQL does not have a concept of "grantor",
so it is not possible to find out which privileges were granted
by a superuser.

It is possible to find out all privileges for a certain user,
but it's probably a bit complicated.

What exactly should be checked?

Yours,
Laurenz Albe

В списке pgsql-general по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: default value returned from sql stmt
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: octet_length operator: what encoding?