your roles query is supposed to return two columns not one as your SQL statement is suggesting.
The first table column should be the Role and the second the RoleGroup, from your query anonymous wrote : <module-option name="rolesQuery">select id_servicio from vivoen.registro where id_usuario=? AND id_website=1 AND (fecha_fin >= NOW() OR fecha_fin IS NULL)</module-option> I assume that id_servicio is the role, but you are not asking for a RoleGroup. From what I have found the Value for RoleGroup should be "Roles" so you could try. | <module-option name="rolesQuery">select id_servicio 'Role', "Roles" AS RoleGroup from vivoen.registro where id_usuario=? AND id_website=1 AND (fecha_fin >= NOW() OR fecha_fin IS NULL)</module-option> Hope this helps Mat View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3839755#3839755 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3839755 ------------------------------------------------------- This SF.Net email sponsored by Black Hat Briefings & Training. Attend Black Hat Briefings & Training, Las Vegas July 24-29 - digital self defense, top technical experts, no vendor pitches, unmatched networking opportunities. Visit www.blackhat.com _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
