Postgres Pro
Downloads
Home   >   mailing lists

Thread: is a user in a group?

is a user in a group?

From
"Jacopo Silva"
Date:
I need to find out a quick way to check which groups a user
is member of.

In the pg_group table each group row has an array of
userids of the members of the group.
At the moment I am selecting all the rows than
searching in each array for the id of the user
I am looking for.

There should be something more elegant than this!!!
There should be a system table which I can use to find
the relation between user and groups.

I would be very grateful to anyone who can help me:-).

Bye,
Jacopo

Re: is a user in a group?

From
Peter Eisentraut
Date:
Jacopo Silva writes:

> There should be something more elegant than this!!!

Correct.  And soon we'll implement something.

> There should be a system table which I can use to find
> the relation between user and groups.

And that is how we'll do it.

> I would be very grateful to anyone who can help me:-).

Sorry, at the moment there's no bettter way.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/

Re: is a user in a group?

From
Jie Liang
Date:
Hi,

You need create a function use PLPGSQL(or PL/Perl) say:

ismember(groupname,username) return bool

since select grolist from pg_group where proname=groupname will return
you an array,
you can use a loop compare each element with the id from usesysid from
pg_user which match username.




Jacopo Silva wrote:

> I need to find out a quick way to check which groups a user
> is member of.
>
> In the pg_group table each group row has an array of
> userids of the members of the group.
> At the moment I am selecting all the rows than
> searching in each array for the id of the user
> I am looking for.
>
> There should be something more elegant than this!!!
> There should be a system table which I can use to find
> the relation between user and groups.
>
> I would be very grateful to anyone who can help me:-).
>
> Bye,
> Jacopo

--
Jie LIANG

Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@ipinc.com
www.ipinc.com

Re: is a user in a group?

From
"Jacopo Silva"
Date:
Thanks!


For now I'll keep on doing searches on arrays,
hoping for a new system table that manages
in a better way the relation between user and
groups.


Bye,
Jacopo



----- Original Message -----
From: "Peter Eisentraut" <peter_e@gmx.net>
To: "Jacopo Silva" <jsilva@lynxtesoft.it>
Cc: <pgsql-admin@postgresql.org>
Sent: Friday, November 10, 2000 5:29 PM
Subject: Re: [ADMIN] is a user in a group?


> Jacopo Silva writes:
>
> > There should be something more elegant than this!!!
>
> Correct.  And soon we'll implement something.
>
> > There should be a system table which I can use to find
> > the relation between user and groups.
>
> And that is how we'll do it.
>
> > I would be very grateful to anyone who can help me:-).
>
> Sorry, at the moment there's no bettter way.
>
> --
> Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/
>