Received: from localhost (pluto.hub.org [200.46.204.4]) by postgresql.org (Postfix) with ESMTP id 334A69F9EEF for ; Fri, 3 Nov 2006 01:32:30 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.4]) (amavisd-new, port 10024) with ESMTP id 24611-07 for ; Fri, 3 Nov 2006 01:32:26 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by postgresql.org (Postfix) with ESMTP id 93C199F98F7 for ; Fri, 3 Nov 2006 01:32:26 -0400 (AST) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1Gfrcq-0007eR-5x for pgsql-sql@postgresql.org; Fri, 03 Nov 2006 06:29:56 +0100 Received: from rvernica-dhcpx38-101.ics.uci.edu ([128.195.38.101]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 03 Nov 2006 06:29:56 +0100 Received: from rvernica by rvernica-dhcpx38-101.ics.uci.edu with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 03 Nov 2006 06:29:56 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-sql@postgresql.org From: Rares Vernica Subject: show privileges Date: Thu, 02 Nov 2006 21:29:05 -0800 Lines: 8 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: rvernica-dhcpx38-101.ics.uci.edu User-Agent: Thunderbird 1.5.0.2 (X11/20060522) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/71 X-Sequence-Number: 26723 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