一般情况下我们login.config里面这样配置:
<application-policy name = "CNInfoStatReport">
<authentication>
<login-module code = "org.jboss.security.auth.spi.DatabaseServerLoginModule"
flag = "required">
<module-option name = "dsJndiName">java:jdbc/Postgres</module-option>
<module-option name = "principalsQuery">
select password from app_user where username=?
</module-option>
<module-option name = "rolesQuery">
select role_name, 'Roles' from user_role where username=?
</module-option>
</login-module>
</authentication>
</application-policy>
但是如果我的用户类型不止一种,不同类的用户在不同的表里。如:公司用户、个人用户,那么在
<module-option name = "principalsQuery"></module-option>里怎么写?