Thread: 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