User privilege information.

On Feb 15, 6:32 am, sqlc...@hotmail.com ("Alexi Gen") wrote:

Hello,

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)
If there a single table/view that can give this information - please point
me to it.
Otherwise - give the names of the tables/views that contain this
information.

Cheers
sqlcatz

_________________________________________________________________
Catch all the cricketing action right here. Live score, match reports,
photos et al.http://content.msn.co.in/Sports/Cricket/Default.aspx

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majord...@postgresql.org so that your
message can get through to the mailing list cleanly

Try \z tableName

anthony

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