Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eB44cJF61953 for ; Sun, 3 Dec 2000 23:38:19 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from hotmail.com (f124.law8.hotmail.com [216.33.241.124]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eARKKft72608 for ; Mon, 27 Nov 2000 15:20:41 -0500 (EST) (envelope-from robburne@hotmail.com) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 27 Nov 2000 12:20:49 -0800 Received: from 194.112.60.146 by lw8fd.law8.hotmail.msn.com with HTTP; Mon, 27 Nov 2000 20:20:49 GMT X-Originating-IP: [194.112.60.146] From: "Rob Burne" To: pgsql-sql@postgresql.org Subject: Access Permissions/Security Date: Mon, 27 Nov 2000 20:20:49 -0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 27 Nov 2000 20:20:49.0345 (UTC) FILETIME=[882B8B10:01C058AF] X-Archive-Number: 200012/18 X-Sequence-Number: 349 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