Home > mailing lists

Re: User privilege information. - Mailing list pgsql-general

From	Michael Fuhr
Subject	Re: User privilege information.
Date	February 15, 2007 14:12:00
Msg-id	20070215151138.GA39379@winnie.fuhr.org Whole thread Raw
In response to	User privilege information. ("Alexi Gen" <sqlcatz@hotmail.com>)
List	pgsql-general

Tree view

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

pgsql-general by date:

From: Alvaro Herrera
Date: 15 February 2007, 13:50:19
Subject: Re: gmake Error "/libpython2.4.a: could not read symbols: Bad value" with ./configure --with-python

From: "John D. Burger"
Date: 15 February 2007, 14:54:27
Subject: Re: Recover anything from dropped database?

Re: User privilege information. - Mailing list pgsql-general

Previous

Next