This content has been marked as final.
Show 1 reply
-
1. Re: EJB-QL query needed
kalyan120 Feb 18, 2005 1:10 AM (in response to sbrbot)One way I can think of is (though not exactly what you wanted):
1. Get all the Roles of the given user: appUser.appRoles()
2. Get all the Roles defined: appRole.fetchAllRoles()
Subtract 1 from 2, and you will have, all the roles that are not assigned to the given user.
Moreover, you need to have a method like appUser.fetchUnassignedRoles() to do the above.
Thanks,
Kalyan.