Re: [SQL] Access Permissions/Security

Start psql w/ -E option and you can see the SQL for all \xxx
commands.

On 27 Nov 2000, at 20:20, Rob Burne wrote:

> Hi,
>
> I need to find the query that will return all security access
> permissions.
>
> For example if a INSERT has been granted to a particular user, how do
> I perform the query which will return this result. I know that the \z
> command returns this, but I need the raw SQL to do it - any ideas
> please?
>
> Many thanks,
>
> Rob.
> ______________________________________________________________________
> _______________ Get more from the Web. FREE MSN Explorer download :
> http://explorer.msn.com

--
Joel Burton, Director of Information Systems -*- jburton(at)scw(dot)org
Support Center of Washington (www.scw.org)