Upon further investigation I found that JBPM uses following 2 queries
<jaas:module-option name='principalsQuery'>
SELECT PASSWORD_ FROM JBPM_ID_USER WHERE NAME_=?
</jaas:module-option>****<jaas:module-option name='rolesQuery'>
SELECT g.NAME_ ,'Roles' FROM JBPM_ID_USER u,
JBPM_ID_MEMBERSHIP m, JBPM_ID_GROUP g
WHERE g.TYPE_='security-role' AND m.GROUP_ = g.ID_ AND
m.USER_ = u.ID_ AND u.NAME_=? </jaas:module-option>
</jaas:login-module>
The first query return result if any of admin, user, manager or shipper is used, however
the second query does not return any record as tables JBPM_ID_MEMBERSHIP and JBPM_ID_GROUP
are empty.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4206892#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...