Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
2 rsolanki 1 
/* User Role List */
2 
SELECT ro.role_id,
3 
	   ro.ROLE_NAME,
4 
	   ro.COMMENTS
5 
  FROM (
6 
 
7 
		SELECT ro.*
8 
		  FROM ROLES ro
9 
		 WHERE ro.APP_ID = :APP_ID
10 
 
11 
		MINUS
12 
 
13 
		SELECT ro.*
14 
		  FROM ROLES ro,
15 
		       USER_ROLES ur
16 
		 WHERE ro.APP_ID = :APP_ID
17 
		   AND ur.USER_ID = :USER_ID
18 
		   AND ur.ROLE_ID = ro.ROLE_ID
19 
 
20 
  		) ro
21 
 WHERE ro.IS_ROLE_VARIATION IS NULL
22 
   AND ro.app_id = :APP_ID
23 
ORDER BY UPPER(ro.role_name)
24