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

Поиск
Список
Период
Сортировка
От raghu ram
Тема Re: how to list all the schema and the privileges which is granted to users.THanks.
Дата
Msg-id CALnrrJQ1Vu2dqEScA2j=aoh_j-Sjp0ETDBHKuUcg6gNHhhP3Gw@mail.gmail.com
обсуждение исходный текст
Ответ на how to list all the schema and the privileges which is granted to users.THanks.  (leaf_yxj <leaf_yxj@163.com>)
Список pgsql-general
Дерево обсуждения


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

В списке pgsql-general по дате отправления:

Предыдущее
От: leaf_yxj
Дата:
Сообщение: how to list all the schema and the privileges which is granted to users.THanks.
Следующее
От: Bryan Hughes
Дата:
Сообщение: Re: Tab completion not working on OSX Lion (10.7.3)