Re: decode access privileges - Mailing list pgsql-general

From John Smith
Subject Re: decode access privileges
Date
Msg-id f029597e0709261602r3d1d515dte1e45046440489b8@mail.gmail.com
Whole thread Raw
In response to Re: decode access privileges  (Michael Glaesemann <grzm@seespotcode.net>)
List pgsql-general
On 9/26/07, Michael Glaesemann <grzm@seespotcode.net> wrote:
>
> On Sep 26, 2007, at 14:51 , John Smith wrote:
>
> > what does this mean?
> >
> > {postgres=arwdRxt/postgres,username=r/postgres}
>
> http://www.postgresql.org/docs/8.2/interactive/sql-grant.html

...purrrfect! thanks michael. i got there by "\dp"

a sorta follow-up:
"\dp" gets access privileges for objects inside the public schema.
how'd i find access privileges for a private schema (not objects
inside that private schema- "\dp schemaname." gets that fine)?

just did a "grant on..." a private schema and wanna see it. something
like "\z schemaname"?
cheers, jzs

pgsql-general by date:

Previous
From: Scott Ribe
Date:
Subject: RETURN NEXT on result set
Next
From: Alvaro Herrera
Date:
Subject: Re: RETURN NEXT on result set