Re: Postgre User Privileges table - Mailing list pgsql-novice

From Joe Conway
Subject Re: Postgre User Privileges table
Date
Msg-id 3E716A43.3000002@joeconway.com
Whole thread Raw
In response to Postgre User Privileges table  (Yovko Ilchev Yovkov <yyovkov@vipsolutions.net>)
List pgsql-novice
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


pgsql-novice by date:

Previous
From: Yovko Ilchev Yovkov
Date:
Subject: Postgre User Privileges table
Next
From: Niclas Hedell
Date:
Subject: Re: get the oid