Re: schema access privs

On Apr 5, 2011, at 2:31 AM, Ray Stell wrote:

> What does the results in col 'List of schemas Access privileges'
> indicate?  Are those three results split by the '/' char?  What
> are the three sections?  What is 'postgres+'
>
> Can't find this explained in the docs.
>
> template1-# \dn+ pg_catalog
>                           List of schemas
>    Name    |  Owner   |  Access privileges   |      Description
> ------------+----------+----------------------+-----------------------
> pg_catalog | postgres | postgres=UC/postgres+| system catalog schema
>            |          | =U/postgres          |
> (1 row)

Following link contains detail about Access privileges:
http://www.postgresql.org/docs/8.4/static/sql-grant.html
       r -- SELECT ("read")
                  w -- UPDATE ("write")
                  a -- INSERT ("append")
                  d -- DELETE
                  D -- TRUNCATE
                  x -- REFERENCES
                  t -- TRIGGER
                  X -- EXECUTE
                  U -- USAGE
                  C -- CREATE
                  c -- CONNECT
                  T -- TEMPORARY
            arwdDxt -- ALL PRIVILEGES (for tables, varies for other objects)
                  * -- grant option for preceding privilege

              /yyyy -- role that granted this privilege

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.kumar@enterprisedb.com
Blog:http://vibhork.blogspot.com