Subversion Repositories DevTools

Rev

Rev 2 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
2 rsolanki 1 
/* Data Permissions */
2 
SELECT dt.table_name, dat.ref_column_val, dat.perm_id, dat.perm_value
3 
  FROM user_roles ur,
4 
       ROLES ro,
5 
       data_permissions dat,
6 
       data_tables dt,
7 
       control_objects co,
8 
       page_control_objects pco,
9 
       application_pages ap
10 
 WHERE ro.role_id = ur.role_id
11 
   AND ro.role_id = dat.role_id
12 
   AND dt.dt_id = dat.dt_id
13 
   AND co.obj_id = dt.obj_id
14 
   AND co.obj_id = pco.obj_id
15 
   AND ap.page_id = pco.page_id
16 
   AND co.app_id = ro.app_id
17 
   AND ap.app_id = ro.app_id
18 
   AND ur.user_id = :USER_ID
19 
   AND ro.app_id = :APP_ID
20 
   AND ap.PAGE_NAME = :PAGE_NAME
21 
   AND ro.IS_ROLE_VARIATION IS NULL
22