pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew G. Hammond <drew@xyzzy.dhs.org>
To: MG <makgab@freemail.hu>
To: pgsql-admin@postgresql.org
Subject: Re: table permissions
Date: Mon, 26 Nov 2001 09:52:19 -0500
Message-ID: <E168N7S-0000Dt-00@xyzzy.lan.internal> (raw)
In-Reply-To: <XFMail.20011122103937.makgab@freemail.hu>
References: <XFMail.20011122103937.makgab@freemail.hu>

-----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-----



view thread (8+ messages)  latest in thread

Message-ID: <E168N7S-0000Dt-00@xyzzy.lan.internal>
Permalink:  ../E168N7S-0000Dt-00@xyzzy.lan.internal/
Also on:    postgresql.org/message-id/E168N7S-0000Dt-00@xyzzy.lan.internal

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: drew@xyzzy.dhs.org, makgab@freemail.hu
  Subject: Re: table permissions
  In-Reply-To: <E168N7S-0000Dt-00@xyzzy.lan.internal>
  References: <XFMail.20011122103937.makgab@freemail.hu> <E168N7S-0000Dt-00@xyzzy.lan.internal>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox