Re: table permissions - Mailing list pgsql-admin

From Andrew G. Hammond
Subject Re: table permissions
Date
Msg-id E168N7S-0000Dt-00@xyzzy.lan.internal
Whole thread Raw
In response to table permissions  (MG <makgab@freemail.hu>)
List pgsql-admin
-----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-----

pgsql-admin by date:

Previous
From: David Bear
Date:
Subject: windoze accesse to pg backend
Next
From: "Lane Rollins"
Date:
Subject: Issues with pg_dump & pg_restore