Skip site navigation (1) Skip section navigation (2)

Re: Discovering privileges

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Murray Cumming <murrayc(at)murrayc(dot)com>
Cc: pgsql-interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: Discovering privileges
Date: 2005-03-20 17:02:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
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.
> > 
> >
> 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

In response to


pgsql-interfaces by date

Next:From: Frank BaxDate: 2005-03-21 03:20:35
Subject: Re: How does one get names of all tables in a DB
Previous:From: Murray CummingDate: 2005-03-20 16:45:29
Subject: Re: Discovering privileges

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group