Received: from olympus.scw.org (209-9-156-98.sdsl.cais.net [209.9.156.98]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eB4KRqG35017 for ; Mon, 4 Dec 2000 15:27:53 -0500 (EST) (envelope-from jburton@scw.org) Received: from hades (eos.scw.org [209.9.156.112]) by olympus.scw.org (8.10.1/8.10.1) with ESMTP id eB4KRXg22232; Mon, 4 Dec 2000 15:27:33 -0500 From: "Joel Burton" Organization: Support Center of Washington To: "Rob Burne" Date: Mon, 4 Dec 2000 15:27:34 -0500 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: Re: [SQL] Access Permissions/Security CC: pgsql-general@postgresql.org Message-ID: <3A2BB7E6.26746.11F825E@localhost> In-reply-to: X-mailer: Pegasus Mail for Win32 (v3.12c) X-Archive-Number: 200012/90 X-Sequence-Number: 1298 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)