From the
psql client, you can view ACL permission summaries by using the
\z slash command. This command displays all access permissions in the currently connected database. To see permissions on a specific object, specify that object's name as a parameter to the
\z command. You can use a regular expression in place of a name to see privileges on a group of objects.
http://www.faqs.org/docs/ppbook/x19270.htm
> To: pgsql-admin@postgresql.org
> From: walterc@indiana.edu
> Subject: [ADMIN] Security Query
> Date: Mon, 12 Nov 2007 09:22:35 -0500
>
> Is there a query I can run that will tell me what access my users
> have to various database objects?
>
> Thanks,
> Carol Walter
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
Climb to the top of the charts! Play Star Shuffle: the word scramble challenge with star power.
Play Now!
