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

"Albe Laurenz" <laurenz.albe@wien.gv.at> writes:
> 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.

Um, we *do* have a concept of grantors, and that information is
recorded.  However, in Postgres any grant or revoke executed by
a superuser is treated as having been done by the object's owner,
so what gets recorded as the grantor in such a case is the owner.
So, right answer, wrong reasoning.

            regards, tom lane