Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id 1E1EE9FB21B
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon,  6 Nov 2006 19:01:13 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 93708-09 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon,  6 Nov 2006 23:01:08 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.170])
	by postgresql.org (Postfix) with ESMTP id 4B7649FB21A
	for <pgsql-sql@postgresql.org>; Mon,  6 Nov 2006 19:01:07 -0400 (AST)
Received: by ug-out-1314.google.com with SMTP id k3so873627ugf
	for <pgsql-sql@postgresql.org>; Mon, 06 Nov 2006 15:01:06 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth;
	b=GAAS9mF3vKPoTpLuAh8jqx5PD5FzT7vJX3Sxs2LdKZoRwQkal1gdy1KT3W4SaGr9gPNyJJh3Un8UywJp4rGurytiVpIuiaKzd8MhqRz16kGII5kyMuO3V7czUUjqGEfuZhx1MfvwqXi6dO11EsexFS3BpC9Axa4ALzjOZkGCHRs=
Received: by 10.78.170.17 with SMTP id s17mr3866449hue.1162854066175;
	Mon, 06 Nov 2006 15:01:06 -0800 (PST)
Received: by 10.78.136.6 with HTTP; Mon, 6 Nov 2006 15:01:06 -0800 (PST)
Message-ID: <bf05e51c0611061501m637979e1g8ba614f6bfe6fe41@mail.gmail.com>
Date: Mon, 6 Nov 2006 17:01:06 -0600
From: "Aaron Bono" <postgresql@aranya.com>
To: "Rares Vernica" <rvernica@gmail.com>
Subject: Re: show privileges
Cc: pgsql-sql@postgresql.org
In-Reply-To: <eiek18$g8p$1@sea.gmane.org>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_44892_26494810.1162854066139"
References: <eiek18$g8p$1@sea.gmane.org>
X-Google-Sender-Auth: 6a43b476ae03de88
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200611/91
X-Sequence-Number: 26743

------=_Part_44892_26494810.1162854066139
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_44892_26494810.1162854066139
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 11/2/06, <b class="gmail_sendername">Rares Vernica</b> &lt;<a href="mailto:rvernica@gmail.com">rvernica@gmail.com</a>&gt; wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi,<br><br>How can I view the privileges that an user or a role has?<br><br>Or what is the equivalent of &quot;show privileges&quot; from MySQL?</blockquote><div><br>&nbsp;</div>select * from pg_user;<br><br>Hey guys, this comes up every so often.&nbsp; Could some kind of syntax be added, at least to the psql tool, to get this kind of information.&nbsp; It would be really handy for administrators.&nbsp; Also, if it were on the documentation under the GRANT privileges section that would help immensely.&nbsp; I always have to hunt this down when I need it.
<br><br>Thanks!<br></div><br>==================================================================<br>&nbsp;&nbsp; Aaron Bono<br>&nbsp;&nbsp; Aranya Software Technologies, Inc.<br>&nbsp;&nbsp; <a href="http://www.aranya.com">http://www.aranya.com</a><br>
&nbsp;&nbsp; <a href="http://codeelixir.com">http://codeelixir.com</a><br>==================================================================

------=_Part_44892_26494810.1162854066139--