pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Tablerights 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