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: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

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

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.



In response to


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