Subversion Repositories DevTools

Rev

Rev 64 | Blame | Compare with Previous | 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)