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

Discovering privileges

From: Murray Cumming <murrayc(at)murrayc(dot)com>
To: pgsql-interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: Discovering privileges
Date: 2005-03-20 14:50:30
Message-ID: 1111330231.5820.4.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-interfaces
I'm using the pg_user and pg_group system tables to discover the list of
users, and the groups to which they belong.

But how can I discover the privileges that these users and groups have
for the various tables. Is this also in one of the system tables?

-- 
Murray Cumming
murrayc(at)murrayc(dot)com
www.murrayc.com
www.openismus.com


In response to

  • Users API at 2004-07-02 20:15:54 from Murray Cumming

Responses

pgsql-interfaces by date

Next:From: Michael FuhrDate: 2005-03-20 15:42:47
Subject: Re: Discovering privileges
Previous:From: Gabor BerenyiDate: 2005-03-18 20:34:11
Subject: fwd: libpq

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