Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group