Hi, I have a 'standard' shiro.ini file.
my userRolesQuery look like this jdbcRealm.userRolesQuery = SELECT role_name FROM role WHERE id = (SELECT r.id FROM role r, admin_user_role a, admin_user u WHERE email = ? and u.id = a.admin_user_id and a.role_id = r.id) but i need one more parameter in my query to determine the roles assigned to a user. like this: jdbcRealm.userRolesQuery = SELECT role_name FROM role WHERE id = (SELECT r.id FROM role r, admin_user_role a, admin_user u WHERE email = ? and conference_id = ? and u.id = a.admin_user_id and a.role_id = r.id) is that possible...and if so....How do I do it. Thanks for any help. Kim -- View this message in context: http://shiro-user.582556.n2.nabble.com/More-parameters-in-role-query-tp7580020.html Sent from the Shiro User mailing list archive at Nabble.com.
