Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 6B2199FA12F for ; Mon, 6 Nov 2006 19:50:00 -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 40575-10 for ; Mon, 6 Nov 2006 23:49:57 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from vms044pub.verizon.net (vms044pub.verizon.net [206.46.252.44]) by postgresql.org (Postfix) with ESMTP id 8FF2E9FA0EF for ; Mon, 6 Nov 2006 19:49:57 -0400 (AST) Received: from [192.168.7.5] ([71.101.12.218]) by vms044.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0J8C00F6C24JH6K8@vms044.mailsrvcs.net> for pgsql-sql@postgresql.org; Mon, 06 Nov 2006 17:48:20 -0600 (CST) Date: Mon, 06 Nov 2006 18:49:15 -0500 From: Joe Subject: Re: show privileges In-reply-to: To: Aaron Bono Cc: Rares Vernica , pgsql-sql@postgresql.org Message-id: <1162856955.703.5.camel@pampa> Organization: Freedom Circle, LLC MIME-version: 1.0 X-Mailer: Evolution 2.8.1.1 FreeBSD GNOME Team Port Content-type: text/plain Content-transfer-encoding: 7bit References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/93 X-Sequence-Number: 26745 On Mon, 2006-11-06 at 17:01 -0600, Aaron Bono wrote: > On 11/2/06, Rares Vernica 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