From: | "John Smith" <jayzee(dot)smith(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | "Michael Glaesemann" <grzm(at)seespotcode(dot)net> |
Subject: | Re: decode access privileges |
Date: | 2007-09-26 23:02:29 |
Message-ID: | f029597e0709261602r3d1d515dte1e45046440489b8@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 9/26/07, Michael Glaesemann <grzm(at)seespotcode(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew Dennis | 2007-09-26 23:03:48 | pg_dump (8.1.9) does not output copy statements |
Previous Message | Scott Ribe | 2007-09-26 23:00:54 | RETURN NEXT on result set |