Re: [SQL] show privileges

[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, 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
==================================================================