Обсуждение: 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