[ic] groups in userdb

[interchange-users@interchange.redhat.com]

My first take on this would be that you may want to create
a table for groups and one that associates a user
with a group.  Putting a group_id on userdb will only allow
users to be in one group, which I have rarely seen to be
acceptable in the long term.

Doesn't solve your problem, just thought you would want to
consider that before moving forward.

Patrick Bennett
http://www.ccgenesis.com

-----Original Message-----
From: Steffen Dettmer [mailto:steffen@dett.de]
Sent: Friday, October 05, 2001 1:15 PM
To: interchange-users@interchange.redhat.com
Subject: [ic] groups in userdb


Hi,

for various reasons I need to organize at least some (hundert)
users in groups. Well, after a while I found where user
authentication is done, it's part of the "core" interchange.
Since I don't want to modify something there, I though it should
work to add the functionality in the catalog by some perl code.
For that, I added a group_id column to the database table (I use
postgres). Via a [data] tag (or similar) it's possible to read
out the gid, but it seems to be a lot of work. I think to store
the gid in the session on first request (as a kind of cache). 

But before I start to implement this, I would like to hear some
comments, maybe I'm on the wrong way with this approach. If
somebody could say a few sentences about it, I would be glad.
Thank you.

oki,

Steffen