Re: Discovering privileges

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:

http://www.postgresql.org/docs/8.0/interactive/sql-grant.html

> > 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.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/