tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Martin Gainty" <mgai...@hotmail.com>
Subject Re: Authentication and authorization questions
Date Thu, 21 Sep 2000 15:10:36 GMT
possible OpenSessionInViewFilter problem
which version hibernate are you implementing with?

M--
----- Original Message -----
From: "jmuller" <jean.2edi@gmail.com>
To: <users@tomcat.apache.org>
Sent: Friday, September 21, 2007 9:14 AM
Subject: Re: Authentication and authorization questions


>
>
> Christopher Schultz-2 wrote:
> >
> > -----BEGIN PGP SIGNED MESSAGE-----
> > ...
> >> How can you use JDBCRealm or DataSourceRealm with [numeric] foreign
keys
> >> from roles
> >> table to user table, rather than requiring the roles table to duplicate
> >> whatever field (e.g. username, email address) will actually be entered
> >> into
> >> the login screen?
> >
> > You can't. You'd have to write your own Realm implementation.
> >
> >> I ask because using simple text-matching rather than using
> >> the primary key of the user table seems a bit inefficient
> >
> > Are you sure about that? You might want to do a performance test on your
> > database. You're likely to find that string matching is /very/ fast,
> > especially if you have the columns indexed (and you really should).
> >
> >> but more
> >> importantly it may be disallowed from data standards in some
> >> organizations.
> > ...
> >
>
> Hello,
> I've got the same problem of a foreign key with 3 tables (generated by
> hibernate) for user and roles:
> - one UserTable with id, name and password,
> - one RoleTable with id and name
> - one RelationTable with userId and roleId
>
> I've written my own DataSourceRealm that overwrite Tomcat's one, and put
the
> jar in server/lib.
> It only overwrites the getRoles() method to change the SQL statement. See
> source here:  http://www.nabble.com/file/p12820411/DataSourceRealm.java
> DataSourceRealm.java  (free to use/modify/comment) !
> --
> View this message in context:
http://www.nabble.com/Authentication-and-authorization-questions-tf4345698.h
tml#a12820411
> Sent from the Tomcat - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>


---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message