[jboss-user] [Security & JAAS/JBoss] - Re: JDBC Realm

[j2ee_junkie]

bjornn,

So far all your config looks good.  The only thing that looks odd is your queries.  These must be made specific to your database.  Specifically, your query...

  | <module-option name = "rolesQuery">SELECT LOGIN, 'Roles' FROM ROLES WHERE LOGIN=?</module-option>
  | 

just returns the login name.  Is this correct?  Other than checking these queries, you will want to look at trace logging output of the login event to see what is going on.

good luck, griffith.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3962564#3962564

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3962564