Help with a query

[Alexander Cohen]

Hi,

Im trying to get a list of all groups that a certain user is a member
of. Can anyone help me with the sql to get that?

thanks!
--
Alexander Cohen
http://www.toomuchspace.com
[phone]
[phone]
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[Erwin Van de Velde]

Hi,

Without further information, this is rather difficult, but assuming that you
have a table with userdata with a primary key UID and a unique UserName, and
that you have a table of usergroups with a primary key GID and unique
GroupName, the best way is to make a third table Users_Usergroups e.g.
where you put the couples (UIDX, GIDX) for a user with UID=UIDX and who is in
group GIDX.
The query would then be:
SELECT GroupName FROM Users_Usergroups JOIN Users ON Users.UID =
Users_Usergroups.UID JOIN Usergroups ON Usergroups.GID = Users_Usergroups.GID
WHERE UserName Like 'The User';

Greetings,
Erwin Van de Velde
Student of University of Antwerp
Belgium
On Thursday 26 February 2004 22:47, Alexander Cohen wrote:

Hi,

Im trying to get a list of all groups that a certain user is a member
of. Can anyone help me with the sql to get that?

thanks!

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[Klint Gore]

On Thu, 26 Feb 2004 16:47:10 -0500, Alexander Cohen <al**@toomuchspace.com> wrote:

Im trying to get a list of all groups that a certain user is a member
of. Can anyone help me with the sql to get that?
select gronamefrom pg_group

where (select usesyside from pg_shadow where usename = 'postgres') =
any(grolist);

klint.

+---------------------------------------+-----------------+
: Klint Gore : "Non rhyming :
: EMail : [e-mail] : slang - the :
: Snail : A.B.R.I. : possibilities :
: Mail University of New England : are useless" :
: Armidale NSW 2351 Australia : L.J.J. :
: Fax : [phone] : :
+---------------------------------------+-----------------+

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org