Re: User privilege information.

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Alexi Gen <sqlcatz(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: User privilege information.
Date: 2007-02-15 15:11:38
Message-ID: 20070215151138.GA39379@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Feb 15, 2007 at 05:02:44PM +0530, Alexi Gen wrote:
> How do I find out the privileges of a particular user?
> (names and ids of the objects and their permissions the user has access to)

See the has_<object>_privilege functions and the system catalogs:

http://www.postgresql.org/docs/8.2/interactive/functions-info.html#FUNCTIONS-INFO-ACCESS-TABLE
http://www.postgresql.org/docs/8.2/interactive/catalogs.html

--
Michael Fuhr

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John D. Burger 2007-02-15 15:53:48 Re: Recover anything from dropped database?
Previous Message Alvaro Herrera 2007-02-15 14:49:51 Re: gmake Error "/libpython2.4.a: could not read symbols: Bad value" with ./configure --with-python