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: 20050320170228.GA19192@winnie.fuhr.org (view raw or flat)
Thread:
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:

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/

In response to

Responses

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-2014 The PostgreSQL Global Development Group