Received: from post.webmailer.de (natpost.webmailer.de [192.67.198.65]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAPI0Im09699 for ; Sun, 25 Nov 2001 13:00:18 -0500 (EST) (envelope-from barwick@gmx.net) Received: from there (pD9EB17F6.dip.t-dialin.net [217.235.23.246]) by post.webmailer.de (8.9.3/8.8.7) with SMTP id TAA04897 for ; Sun, 25 Nov 2001 19:00:11 +0100 (MET) Message-Id: <200111251800.TAA04897@post.webmailer.de> Content-Type: text/plain; charset="iso-8859-1" From: Ian Barwick To: pgsql-admin@postgresql.org Subject: Re: table permissions Date: Sun, 25 Nov 2001 18:01:54 +0100 X-Mailer: KMail [version 1.3.1] References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Archive-Number: 200111/127 X-Sequence-Number: 2652 On Thursday 22 November 2001 11:39, MG wrote: > Hi! > > I subscribe to this list now. :) I have a question. > How can I query (in SQL) the user permissions of a table? Which system > table stores the tables permissions for the user? Sounds like you are looking for table pg_class, column relacl. See: http://www.postgresql.org/idocs/index.php?catalog-pg-class.html HTH Ian Barwick