Received: from post.webmailer.de (natpost.webmailer.de [192.67.198.65]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAOMkUm51161 for ; Sat, 24 Nov 2001 17:46:30 -0500 (EST) (envelope-from barwick@gmx.net) Received: from there (pD9E0EB09.dip.t-dialin.net [217.224.235.9]) by post.webmailer.de (8.9.3/8.8.7) with SMTP id XAA16488; Sat, 24 Nov 2001 23:46:30 +0100 (MET) Message-Id: <200111242246.XAA16488@post.webmailer.de> Content-Type: text/plain; charset="iso-8859-1" From: Ian Barwick To: MG , pgsql-admin@postgresql.org Subject: Re: table permissions Date: Sat, 24 Nov 2001 23:46:27 +0100 X-Mailer: KMail [version 1.3.1] References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Archive-Number: 200111/128 X-Sequence-Number: 2653 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 pg_class, column relacl. See: http://www.postgresql.org/idocs/index.php?catalog-pg-class.html HTH Ian Barwick