Thread: table permissions
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? Bye! ---------------- Linux Redhat 7.1 ----------------
At 10:39 AM 11/22/01 +0000, MG wrote:
>How can I query (in SQL) the user permissions of a table? Which system table
>stores the tables permissions for the user?
select * from pg_user ;
-crl
--
Chad R. Larson (CRL22) chad@eldocomp.com
Eldorado Computing, Inc. 602-604-3100
5353 North 16th Street, Suite 400
Phoenix, Arizona 85016-3228
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 table pg_class, column relacl. See: http://www.postgresql.org/idocs/index.php?catalog-pg-class.html HTH Ian Barwick
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
-----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-----