[GENERAL] 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 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] User privilege information.
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 ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] User privilege information.
On Feb 15, 6:32 am, [EMAIL PROTECTED] (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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly Try \z tableName anthony ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/