Blame | Last modification | View Log | RSS feed
/* User Roles */ SELECT ro.ROLE_ID, ro.ROLE_NAME, ro.COMMENTS FROM ROLES ro, USER_ROLES ur WHERE ur.ROLE_ID = ro.ROLE_ID AND ur.USER_ID = :USER_ID AND ro.APP_ID = :APP_ID ORDER BY UPPER(ro.ROLE_NAME)
/* User Roles */
SELECT ro.ROLE_ID,
ro.ROLE_NAME,
ro.COMMENTS
FROM ROLES ro,
USER_ROLES ur
WHERE ur.ROLE_ID = ro.ROLE_ID
AND ur.USER_ID = :USER_ID
AND ro.APP_ID = :APP_ID
ORDER BY UPPER(ro.ROLE_NAME)