Re: table permissions

-----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(at)xyzzy(dot)dhs(dot)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-----