Обсуждение: 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.

От
leaf_yxj
Дата:
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.

От
raghu ram
Дата:


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