"Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> writes:
> leaf_yxj wrote:
>> My bosses ask me to list all the users and all the privilege which
> the superuser granted to the
>> 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
In response to
pgsql-general by date
|Next:||From: Craig Ringer||Date: 2012-03-30 14:19:28|
|Subject: Re: PostgreSQL crashed server|
|Previous:||From: Katherine Jeschke||Date: 2012-03-30 14:04:53|
|Subject: Surge 2012 CFP is Open!|