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
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.htmlTo 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: Re:Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
