Tom Lane 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. Oops, you're right of course. Sorry for causing confusion. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
