"Albe Laurenz" <laurenz.albe@xxxxxxxxxx> writes: > 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. Um, we *do* have a concept of grantors, and that information is recorded. However, in Postgres any grant or revoke executed by a superuser is treated as having been done by the object's owner, so what gets recorded as the grantor in such a case is the owner. So, right answer, wrong reasoning. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
