Обсуждение: Postgre User Privileges table

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Can anyone tell where in which table are described users priveleges for the
tables?
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE+cGInfhWWBihFTo0RAsAyAKCrd9y+dPHm7lbJT3ksfiVr83YLqwCgken/
D27AohO0/oAUwMYBy89ck2w=
=Vdcq
-----END PGP SIGNATURE-----

Yovko Ilchev Yovkov wrote:
> Can anyone tell where in which table are described users priveleges for the
> tables?

Privileges are tracked in a column (relacl) of the pg_class table for
relations. See:

http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/catalog-pg-class.html
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/sql-grant.html
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/functions-misc.html

for related information.

HTH,

Joe