Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
2 rsolanki 1 
/* Role Object Pairs for User Permissions */
2 
SELECT DISTINCT ro.ROLE_ID,
3 
       rp.OBJ_ID
4 
  FROM ROLES ro,
5 
  	   USER_ROLES ur,
6 
       ROLE_PRIVILEGES rp
7 
 WHERE ur.ROLE_ID = ro.ROLE_ID
8 
   AND rp.ROLE_ID = ro.ROLE_ID
9 
   AND ro.APP_ID = :APP_ID
10 
   AND ur.USER_ID = :USER_ID
11 
 
12 
 
13 
MINUS
14 
 
15 
/* Take away roles overwritten by role variation */
16 
SELECT DISTINCT ro.ROLE_ID,
17 
       rp.OBJ_ID
18 
  FROM ROLES ro,
19 
  	   USER_ROLES ur,
20 
       ROLE_PRIVILEGES rp,
21 
	   (
22 
	    /* Objects for Role Variation Only */
23 
		SELECT rp.OBJ_ID
24 
		  FROM ROLES ro,
25 
		  	   USER_ROLES ur,
26 
			   ROLE_PRIVILEGES rp
27 
		 WHERE ur.ROLE_ID = ro.ROLE_ID
28 
		   AND rp.ROLE_ID = ro.ROLE_ID
29 
		   AND ro.APP_ID = :APP_ID
30 
		   AND ur.USER_ID = :USER_ID
31 
		   AND ro.IS_ROLE_VARIATION = 'Y'
32 
	   ) rvco
33 
 WHERE ur.ROLE_ID = ro.ROLE_ID
34 
   AND rp.ROLE_ID = ro.ROLE_ID
35 
   AND ro.APP_ID = :APP_ID
36 
   AND ur.USER_ID = :USER_ID
37 
   AND rp.OBJ_ID = rvco.OBJ_ID
38 
   AND ro.IS_ROLE_VARIATION IS NULL
39