Subversion Repositories DevTools

Rev

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

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