Tablerights for User in Group

From: ListSrv <listsrv(at)wilsoft(dot)nl>
To: pgsql-admin(at)postgresql(dot)org
Subject: Tablerights for User in Group
Date: 2004-01-12 21:06:01
Message-ID: 40030C39.5030806@wilsoft.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

Is it possible to query de backend database for retrieving rights of an
user in a group for a
table?

I know that the userrights can be retrieved as:

SELECT relacl FROM pg_class WHERE relname = '[table name]'

and the users-id in groups as:

SELECT grolist from pg_group where groname = 'group'

the user-id;

SELECT usesysid from pg_user where usename = 'name';

How can I query

SELECT rights FROM table WHERE usename = 'name' AND relname = '[tablename]' ....

Otherwise I have to query the backend and parse and parse and parse .... the results.

TIA

WIllem.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno Wolff III 2004-01-12 21:21:38 Re: Tablerights for User in Group
Previous Message Michael Stenitzer 2004-01-12 18:49:16 Re: cannot configure postgres