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

Hi Albe,

My bosses ask me to list

1)all the users and the roles associated with the users.
2) all the users and the privileges associated with that users.

Thanks.

Regards.

Grace

At 2012-03-30 16:07:08,"Albe Laurenz *EXTERN* [via PostgreSQL]" <ml-node+s1045698n5605960h2(at)n5(dot)nabble(dot)com> wrote:
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

--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

If you reply to this email, your message will be added to the discussion below:
http://postgresql.1045698.n5.nabble.com/double-check-the-role-has-what-s-kind-of-the-privilege-And-the-same-for-the-objects-Thanks-tp5605564p5605960.html
To unsubscribe from double check the role has what's kind of the privilege? And the same for the objects. Thanks., click here.
NAML

--
View this message in context: http://postgresql.1045698.n5.nabble.com/double-check-the-role-has-what-s-kind-of-the-privilege-And-the-same-for-the-objects-Thanks-tp5605564p5606709.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.