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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Frank Bax | 2005-03-21 03:20:35 | Re: How does one get names of all tables in a DB |
Previous Message | Murray Cumming | 2005-03-20 16:45:29 | Re: Discovering privileges |