Hi Ian, Thanks for pointing me to the links. Coming back to the realm, as far as I know, JDBCRealm does not allow you to run arbitrary SQL queries against the database to retrieve the role/password information. I believe, this can be solved to some extent by creating appropriate views in the database. What SQLRealm offers is the flexibility to pass in additional parameters to the query (say, an organizationid or a departmentid) as part of j_username value, delimited by some character. I understand that appending these extra parameters to j_username is definitely a workaround, but it has proved to be quite useful in a few projects.
Please do take a look at http://mirroronthenet.org/blog , if you can spare a couple of minutes. Thanks Neelesh
