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]" <[hidden email]> 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.