Re: [SQL] Access Permissions/Security - Mailing list pgsql-general

From Joel Burton
Subject Re: [SQL] Access Permissions/Security
Date
Msg-id 3A2BB7E6.26746.11F825E@localhost
Whole thread Raw
List pgsql-general
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@scw.org
Support Center of Washington (www.scw.org)

pgsql-general by date:

Previous
From: Nancy Ellman
Date:
Subject: Where do COMMENTs on columns go?
Next
From: "Alistair Hopkins"
Date:
Subject: RE: Built in Functions use with recordsets