pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedshow privileges
3+ messages / 3 participants
[nested] [flat]
* show privileges
@ 2006-11-03 05:29 Rares Vernica <rvernica@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Rares Vernica @ 2006-11-03 05:29 UTC (permalink / raw)
To: pgsql-sql
Hi,
How can I view the privileges that an user or a role has?
Or what is the equivalent of "show privileges" from MySQL?
Thanks,
Ray
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: show privileges
@ 2006-11-06 23:01 Aaron Bono <postgresql@aranya.com>
parent: Rares Vernica <rvernica@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Aaron Bono @ 2006-11-06 23:01 UTC (permalink / raw)
To: Rares Vernica <rvernica@gmail.com>; +Cc: pgsql-sql
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.
Thanks!
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: show privileges
@ 2006-11-06 23:49 Joe <dev@freedomcircle.net>
parent: Aaron Bono <postgresql@aranya.com>
0 siblings, 0 replies; 3+ messages in thread
From: Joe @ 2006-11-06 23:49 UTC (permalink / raw)
To: Aaron Bono <postgresql@aranya.com>; +Cc: Rares Vernica <rvernica@gmail.com>; pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-11-06 23:49 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-11-03 05:29 show privileges Rares Vernica <rvernica@gmail.com>
2006-11-06 23:01 ` Aaron Bono <postgresql@aranya.com>
2006-11-06 23:49 ` Joe <dev@freedomcircle.net>
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