Re: [SQL] Viewing access privileges - Mailing list pgsql-sql

Stephen Davies wrote:
>
> How can one view all of the access privileges of one or more users?
>
> That is, how can I check what I have GRANTed to whom?

Try this:
SELECT relname,relacl FROM pg_class WHERE relname !~ '^pg_';

--
Tim J Trowbridge                         trowbrid@writeme.com
Interested in my genealogy?          http://www.execpc.com/~trowbrid