Thread: 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