Re: [JBoss-user] Re: more than one LoginModule

[Scott M S. <sco...@at...>]

Use:
<module-option name = "rolesQuery">select 'merchant', 'Roles'</module-option>

xxxxxxxxxxxxxxxxxxxxxxxx
Scott Stark
Chief Technology Officer
JBoss Group, LLC
xxxxxxxxxxxxxxxxxxxxxxxx

----- Original Message ----- 
From: "costin" <gic...@ed...>
To: <jbo...@li...>
Sent: Friday, May 23, 2003 5:18 AM
Subject: [JBoss-user] Re: more than one LoginModule


> Hi!
> 
>    Well, I have forgot about the flag thing, so making the first module
> "sufficient" and the other required did the thing.
> However, I have problem with the DatabaseServerLoginModule.
>    In my case I have only a table with a lot of fields from which I can
> extract the user/pass but I all the users from this module have the
> same role.
> 
> Now I have only one login-module which goes like this:
> <snip>
>            <login-module code = "org.jboss.security.auth.spi.DatabaseServerLoginModule"
>              flag = "required">
>             <module-option name = "unauthenticatedIdentity">nobody</module-option>
>             <module-option name = "dsJndiName">java:/MySqlDS</module-option>
>             <module-option name = "principalsQuery">select emv from minimerchants where name=?</module-option>        
>             <module-option name = "rolesQuery">select 'merchant', 'merchant'</module-option>
>           </login-module>
> </snip>