On Sun, Mar 20, 2005 at 05:45:29PM +0100, Murray Cumming wrote:
> On Sun, 2005-03-20 at 08:42 -0700, Michael Fuhr wrote:
> > You could look at pg_class.relacl,
> I can't make much sense of that so far. Ca you give any clues on how
> that works?
See "Notes" in the GRANT documentation:
> > but the "Access Privilege Inquiry
> > Functions" (has_table_privilege(), etc.) might be easier to use.
> > http://www.postgresql.org/docs/8.0/interactive/functions-info.html#FUNCTIONS-INFO-ACCESS-TABLE
> Interesting. Is there anything like that for a group instead of a user?
> I'm most interested in privileges of a group.
Hmmm...not sure. I suppose you could create a user that belongs
only to a particular group and check that user's privileges.
In response to
pgsql-interfaces by date
|Next:||From: Frank Bax||Date: 2005-03-21 03:20:35|
|Subject: Re: How does one get names of all tables in a DB|
|Previous:||From: Murray Cumming||Date: 2005-03-20 16:45:29|
|Subject: Re: Discovering privileges|