Обсуждение: 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-----