Re: Postgre User Privileges table

From: Joe Conway <mail(at)joeconway(dot)com>
To: Yovko Ilchev Yovkov <yyovkov(at)vipsolutions(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Postgre User Privileges table
Date: 2003-03-14 05:36:03
Message-ID: 3E716A43.3000002@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Fred Soustra 2003-03-14 08:40:45 Problems with copy
Previous Message eurlix 2003-03-13 20:43:19 what version of gcc and pg ?