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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
Cc: "leaf_yxj *EXTERN*" <leaf_yxj(at)163(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.
Date: 2012-03-30 14:16:48
Message-ID: 4985.1333117008@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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
>> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2012-03-30 14:19:28 Re: PostgreSQL crashed server
Previous Message Katherine Jeschke 2012-03-30 14:04:53 Surge 2012 CFP is Open!