>From the psql client, you can view ACL permission summaries by using the \z >slash command. This command displays all access permissions in the currently >connected database. To see permissions on a specific object, specify that >object's name as a parameter to the \z command. You can use a regular >expression in place of a name to see privileges on a group of objects. http://www.faqs.org/docs/ppbook/x19270.htm
> To: [email protected]> From: [EMAIL PROTECTED]> Subject: [ADMIN] > Security Query> Date: Mon, 12 Nov 2007 09:22:35 -0500> > Is there a query I > can run that will tell me what access my users > have to various database > objects?> > Thanks,> Carol Walter> > ---------------------------(end of > broadcast)---------------------------> TIP 2: Don't 'kill -9' the postmaster _________________________________________________________________ Climb to the top of the charts! Play Star Shuffle: the word scramble challenge with star power. http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_oct
