Thread: how to list all the schema and the privileges which is granted to users.THanks.
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?? Thanks. Regards. Grace -- View this message in context: http://postgresql.1045698.n5.nabble.com/how-to-list-all-the-schema-and-the-privileges-which-is-granted-to-users-THanks-tp5639852p5639852.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
Re: how to list all the schema and the privileges which is granted to users.THanks.
From
raghu ram
Date:
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