Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
2 rsolanki 1 
/* Control Privileges */
2 
SELECT roc.ROLE_ID,
3 
	   roc.ROLE_NAME,
4 
	   :OBJ_ID AS OBJ_ID,
5 
	   perm_visible.PERM_ID AS perm_visible_id,
6 
	   perm_visible.PERM_VALUE AS visible_value,
7 
	   perm_active.PERM_ID AS perm_active_id,
8 
	   perm_active.PERM_VALUE AS active_value
9 
  FROM
10 
	   (
11 
 
12 
		/* Get All Roles for this Application */
13 
	    SELECT ro.ROLE_ID,
14 
			   ro.ROLE_NAME
15 
		  FROM ROLES ro
16 
		 WHERE ro.APP_ID = :APP_ID
17 
		   AND ro.IS_ROLE_VARIATION IS NULL
18 
 
19 
 
20 
	   ) roc,
21 
	   (
22 
 
23 
	    /* Get "Visible" Settings */
24 
	   	SELECT rp.ROLE_ID,
25 
			   co.OBJ_ID,
26 
			   rp.PERM_ID,
27 
			   rp.PERM_VALUE
28 
		  FROM ROLE_PRIVILEGES rp,
29 
		  	   CONTROL_OBJECTS co
30 
	     WHERE rp.OBJ_ID = co.obj_id
31 
		   AND co.OBJ_ID = :OBJ_ID
32 
		   AND rp.PERM_ID = 1
33 
		   AND co.APP_ID = :APP_ID
34 
 
35 
	   ) perm_visible,
36 
	   (
37 
 
38 
	    /* Get "Active" Settings */
39 
	   	SELECT rp.ROLE_ID,
40 
			   co.OBJ_ID,
41 
			   rp.PERM_ID,
42 
			   rp.PERM_VALUE
43 
		  FROM ROLE_PRIVILEGES rp,
44 
		  	   CONTROL_OBJECTS co
45 
	     WHERE rp.OBJ_ID = co.obj_id
46 
		   AND co.OBJ_ID = :OBJ_ID
47 
		   AND rp.PERM_ID = 2
48 
		   AND co.APP_ID = :APP_ID
49 
 
50 
	   ) perm_active
51 
 
52 
 WHERE perm_active.role_id (+)= roc.role_id
53 
   AND perm_visible.role_id (+)= roc.role_id
54 
 
55 
 
56 
ORDER BY UPPER(roc.ROLE_NAME)