pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedTablerights for User in Group
3+ messages / 2 participants
[nested] [flat]
* Tablerights for User in Group
@ 2004-01-12 21:06 ListSrv <listsrv@wilsoft.nl>
0 siblings, 1 reply; 3+ messages in thread
From: ListSrv @ 2004-01-12 21:06 UTC (permalink / raw)
To: 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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Tablerights for User in Group
@ 2004-01-12 21:21 Bruno Wolff III <bruno@wolff.to>
parent: ListSrv <listsrv@wilsoft.nl>
0 siblings, 1 reply; 3+ messages in thread
From: Bruno Wolff III @ 2004-01-12 21:21 UTC (permalink / raw)
To: ListSrv <listsrv@wilsoft.nl>; +Cc: pgsql-admin
On Mon, Jan 12, 2004 at 22:06:01 +0100,
ListSrv <listsrv@wilsoft.nl> wrote:
> Hi,
>
> Is it possible to query de backend database for retrieving rights of an
> user in a group for a
> table?
In 7.4 there is a group of functions that seem to do what you want.
The functions are listed in table 9-37 which is in the section for
miscellaneous functions.
I think these functions are a relatively recent addition, and that you may
need to be running 7.4 to use them.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Tablerights for User in Group
@ 2004-01-12 22:44 ListSrv <listsrv@wilsoft.nl>
parent: Bruno Wolff III <bruno@wolff.to>
0 siblings, 0 replies; 3+ messages in thread
From: ListSrv @ 2004-01-12 22:44 UTC (permalink / raw)
To: pgsql-admin
Bruno,,
Perfect, exactly what I was looking for. It's is also available in
version 7.3.x which I use.
RTFM , I would say.... :-[
Thanks,
Willem
Bruno Wolff III wrote:
>On Mon, Jan 12, 2004 at 22:06:01 +0100,
> ListSrv <listsrv@wilsoft.nl> wrote:
>
>
>>Hi,
>>
>>Is it possible to query de backend database for retrieving rights of an
>>user in a group for a
>>table?
>>
>>
>
>In 7.4 there is a group of functions that seem to do what you want.
>
>The functions are listed in table 9-37 which is in the section for
>miscellaneous functions.
>
>I think these functions are a relatively recent addition, and that you may
>need to be running 7.4 to use them.
>
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-01-12 22:44 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-01-12 21:06 Tablerights for User in Group ListSrv <listsrv@wilsoft.nl>
2004-01-12 21:21 ` Bruno Wolff III <bruno@wolff.to>
2004-01-12 22:44 ` ListSrv <listsrv@wilsoft.nl>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox