Skip site navigation (1) Skip section navigation (2)

Re: decode access privileges

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: (view raw, whole thread or download thread mbox)
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}

...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

In response to

pgsql-general by date

Next:From: Matthew DennisDate: 2007-09-26 23:03:48
Subject: pg_dump (8.1.9) does not output copy statements
Previous:From: Scott RibeDate: 2007-09-26 23:00:54
Subject: RETURN NEXT on result set

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group