From: Joe <dev@freedomcircle.net>
To: Aaron Bono <postgresql@aranya.com>
Cc: Rares Vernica <rvernica@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: show privileges
Date: Mon, 06 Nov 2006 18:49:15 -0500
Message-ID: <1162856955.703.5.camel@pampa> (raw)
In-Reply-To: <bf05e51c0611061501m637979e1g8ba614f6bfe6fe41@mail.gmail.com>
References: <eiek18$g8p$1@sea.gmane.org>
<bf05e51c0611061501m637979e1g8ba614f6bfe6fe41@mail.gmail.com>
On Mon, 2006-11-06 at 17:01 -0600, Aaron Bono wrote:
> On 11/2/06, Rares Vernica <rvernica@gmail.com> wrote:
> Hi,
>
> How can I view the privileges that an user or a role has?
>
> Or what is the equivalent of "show privileges" from MySQL?
>
>
> select * from pg_user;
>
> Hey guys, this comes up every so often. Could some kind of syntax be
> added, at least to the psql tool, to get this kind of information. It
> would be really handy for administrators. Also, if it were on the
> documentation under the GRANT privileges section that would help
> immensely. I always have to hunt this down when I need it.
You mean something like \du at the psql prompt?
Joe
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@freedomcircle.net, postgresql@aranya.com, rvernica@gmail.com
Subject: Re: show privileges
In-Reply-To: <1162856955.703.5.camel@pampa>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox