From: | raghu ram <raghuchennuru(at)gmail(dot)com> |
---|---|
To: | leaf_yxj <leaf_yxj(at)163(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: how to list all the schema and the privileges which is granted to users.THanks. |
Date: | 2012-04-14 02:09:48 |
Message-ID: | CALnrrJQ1Vu2dqEScA2j=aoh_j-Sjp0ETDBHKuUcg6gNHhhP3Gw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sat, Apr 14, 2012 at 6:47 AM, leaf_yxj <leaf_yxj(at)163(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-04-14 02:52:17 | Re: Tab completion not working on OSX Lion (10.7.3) |
Previous Message | leaf_yxj | 2012-04-14 01:17:56 | how to list all the schema and the privileges which is granted to users.THanks. |