Dynamic rewriting

[Craig Vincent]

Server:  Linux RH 6.1, Apache 1.3.9/mod_perl Problem involves Apache::AuthenDBI, AuthzDBI & mod_rewrite   I realize my question isn't really mod_perl based (more mod_rewrite) however I've searched everywhere for a solution to this and so far have come up short.  However since my problem directly involves Apache::AuthenDBI/AuthzDBI I'm hoping perhaps someone here has crossed a similar situation.   I'm currently authenticating users thru MySQL.  This work perfectly no problems.   Now the issue lies is that my users fall under three categories (groups) and currently I can validate users if they belong to any one of these three categories.   <snip> require group admin standard basic </snip>   The problem with this is all three users currently will wind up initially going to the same CGI script.  Where it rechecks their information and then redirects them to the appropriate area.  I don't like this because it creates an extra process on the server per login which means now three processes per login (HTTPD, DBI, CGI).  On top of that it isn't transparent to the user which I personally dislike.   A solution I was looking at to solve both my concerns was using mod_rewrite however so far I have only been successful in having it do redirections based on the username of the individual...not the group.  This is useless to me as usernames and the groups they belong are added/removed constantly and I don't want to be hardcoding all the usernames for each group manually.   So my question is this:   Has anyone been successful (or have any theories) in redirecting a user using mod_rewrite based on the group the user belongs to?\   Once again I apologize for this being off topic but I'm at my wits end with this :(   Sincerely,   Craig Vincent Senior Webmaster/Programmer