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
