how to list all the schema and the privileges which is granted to users.THanks.

On Sat, Apr 14, 2012 at 6:47 AM, leaf_yxj <leaf_yxj@163.com> wrote:

how to list all the schema and the privileges which is granted to
users.THanks.

I know how to list all the objects privileges :
\dp

But I don't know how to list the schema's privileges??

Schema Privileges:

postgres=# \dn+
List of schemas
Name | Owner | Access privileges |
Description
--------------------+----------+-------------------------------------+----------------------------------
information_schema | postgres | {postgres=UC/postgres,=U/postgres} |
pg_catalog | postgres | {postgres=UC/postgres,=U/postgres} |
system catalog schema
pg_toast | postgres | |
reserved schema for TOAST tables
pg_toast_temp_1 | postgres | |
public | postgres | {postgres=UC/postgres,=UC/postgres} |
standard public schema
(5 rows)

--

Thanks & Regards,

Raghu Ram

EnterpriseDB: http://www.enterprisedb.com