Re: [SQL] show privileges

2006-11-06 Thread Joe
On Mon, 2006-11-06 at 17:01 -0600, Aaron Bono wrote: > On 11/2/06, Rares Vernica <[EMAIL PROTECTED]> 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 *

Re: [SQL] show privileges

2006-11-06 Thread Aaron Bono
On 11/2/06, Rares Vernica <[EMAIL PROTECTED]> 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, t

[SQL] show privileges

2006-11-06 Thread Rares Vernica
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 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-no