Re: schema access privs

From: Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com>
To: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
Cc: "pgsql-general(at)postgresql(dot)org List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: schema access privs
Date: 2011-04-05 10:28:46
Message-ID: 24CBDD5F-13E1-4D96-9026-AAA540F2BA70@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

[ Please don't overpost the list. Adding PG General List]

On Apr 5, 2011, at 3:30 AM, Ray Stell wrote:

> On Tue, Apr 05, 2011 at 02:42:30AM +0530, Vibhor Kumar wrote:
>>
>> 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+'
>>
>> Following link contains detail about Access privileges:
>> http://www.postgresql.org/docs/8.4/static/sql-grant.html
>
> yeah, I saw that, but that's not what I asked about. there seems
> to be 3 sections of the result. What are the sections? and what is
> postgres+ ?

Following are details:
postgres=UC/postgres+
[user] [privs] /[ ROLE who granted privs.

Postgres is a user which has granted USAGE and CREATE Privileges to user postgres

+ seems a wrapper in next line.

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc-André Goderre 2011-04-05 12:16:00 Trigger vs web service
Previous Message Jeremy Palmer 2011-04-05 09:50:44 Out of memory