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

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 (view raw or flat)
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

pgsql-admin by date

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

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