Re: [GENERAL] User privilege information.

2007-02-15 Thread tonylaq
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. > Oth

Re: [GENERAL] User privilege information.

2007-02-15 Thread Michael Fuhr
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__privilege functions and the system catalogs: http://www.postgresql.org/docs/8.2/interactiv