On Sun, Mar 20, 2005 at 03:50:30PM +0100, Murray Cumming wrote:
> I'm using the pg_user and pg_group system tables to discover the list of
> users, and the groups to which they belong.
> But how can I discover the privileges that these users and groups have
> for the various tables. Is this also in one of the system tables?
You could look at pg_class.relacl, but the "Access Privilege Inquiry
Functions" (has_table_privilege(), etc.) might be easier to use.
In response to
pgsql-interfaces by date
|Next:||From: Bruno Wolff III||Date: 2005-03-20 15:52:30|
|Subject: Re: Discovering privileges|
|Previous:||From: Murray Cumming||Date: 2005-03-20 14:50:30|
|Subject: Discovering privileges|