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

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "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 08:05:53
Message-ID: D960CB61B694CF459DCFB4B0128514C207B2C09F@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2012-03-30 08:10:41 Re: octet_length operator: what encoding?
Previous Message Pavel Stehule 2012-03-30 07:46:52 Re: default value returned from sql stmt