Received: from xyzzy.lan.internal (d226-90-175.home.cgocable.net [24.226.90.175]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAQEqWm02448 for ; Mon, 26 Nov 2001 09:52:32 -0500 (EST) (envelope-from drew@xyzzy.dhs.org) Received: from localhost ([127.0.0.1] helo=there ident=drew) by xyzzy.lan.internal with smtp (Exim 3.32 #1 (Debian)) id 168N7S-0000Dt-00; Mon, 26 Nov 2001 09:52:26 -0500 Content-Type: text/plain; charset="iso-8859-1" From: "Andrew G. Hammond" To: MG , pgsql-admin@postgresql.org Subject: Re: table permissions Date: Mon, 26 Nov 2001 09:52:19 -0500 X-Mailer: KMail [version 1.3.2] References: In-Reply-To: MIME-Version: 1.0 Message-Id: Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id fAQF3On04978 X-Archive-Number: 200111/131 X-Sequence-Number: 2656 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 2001 November 22 05:39 am, MG wrote: > 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? psql -E test \dp displays the query used by psql to list permissions in the filesystem: SELECT relname as "Relation", relacl as "Access permissions" FROM pg_class WHERE relkind in ('r', 'v', 'S') AND relname !~ '^pg_' ORDER BY relname - -- Andrew G. Hammond mailto:drew@xyzzy.dhs.org http://xyzzy.dhs.org/~drew/ 56 2A 54 EF 19 C0 3B 43 72 69 5B E3 69 5B A1 1F 613-389-5481 5CD3 62B0 254B DEB1 86E0 8959 093E F70A B457 84B1 "To blow recursion you must first blow recur" -- me -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iEYEARECAAYFAjwCVycACgkQCT73CrRXhLE+1gCeOSoMV8Qp9cKijAHxTuxamMPz m0wAn21MFM/y7+BneRF4BpzZKG33bNWq =/JIx -----END PGP SIGNATURE-----