I'm trying to use Mysql als login database but i run into sevral problems.
1) my roles database is composed of 2 items,
--MainFunction related(say default roles) and person relates(roles)
my role file is a union of 2 queries connected with a variable.
doing so I select 3 Coloms instead of 2 Coloms, (RoleID, RoleGroup, a bogus
one)
this seems to lock up the DatabaseServletLoginModule
any idea's on how to solve this
Query:
<module-option name = "rolesQuery">
SELECT allow as ROLEID, Role as RoleGroup ,@f:=at.Func FROM authorize
ah,authenticate at
WHERE at.user_name=ah.user_name
AND (at.user_name=?) AND (at.Domain='domain')
union select allow as ROLE, Role as RoleGroup , 'add' FROM authorize as
ah1 WHERE [EMAIL PROTECTED] </module-option>
</login-module>
Alternatively I had a look in using a stored procedure to add a kind of
logging on roles access and doing the above in a stored procedures.
the DatabaseServletLoginModule does not seem to like store procedures either.
query:
"rolesQuery"> call Roles(?)</module-option>
Any idea's on how to solve this
Thanks in advancce
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4045385#4045385
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4045385
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user
