Обсуждение: User privilege information.

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

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

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