tomcat-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ignacio J. Ortega" <na...@siapi.es>
Subject RE: [PATCH] change JDBCRealm to add flexibility in table layout
Date Tue, 05 Mar 2002 08:44:47 GMT
> De: John Gregg [mailto:john.gregg@techarch.com]
> Enviado el: martes 5 de marzo de 2002 1:27

> in the layout of one's users and roles tables.  The current 
> implementation
> (1.20) assumes the roles table will have a column with the 
> same name and
> meaning as the username column in the users table.  In 
> general, I like to
> avoid using a column with domain meaning as a primary or 
> foreign key.  In

Why do not use simply a views, instead of real tables..??

This way you doesnt need to do any changes in JDBCRealm to be able to
use whatever column you like to join roles and users tables.. ( that
seems what you are looking for , arent you?)

If more is needed please explain why.. perhaps i dont understand fully
what you need ..

And sure, the view method will not work with mysql ( doesnt have views
afaik ).., but will for postgress AFAIK..

Saludos ,
Ignacio J. Ortega



--
To unsubscribe, e-mail:   <mailto:tomcat-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-dev-help@jakarta.apache.org>


Mime
View raw message