Oracle E-Business Suite: SYSADMIN Yetkisinin Verilmesi - Giving The SYSADMIN Responsibility To Users

Her kullanıcıya "sysadmin"  yetkisini verilmesi:

 select user_name, user_id  
 from fnd_user  
 where user_name like '&username'  
 /  
   
 insert into fnd_user_responsibility(  
 USER_ID,  
 APPLICATION_ID,  
 RESPONSIBILITY_ID,  
 LAST_UPDATE_DATE,  
 LAST_UPDATED_BY,  
 CREATION_DATE,  
 CREATED_BY,  
 LAST_UPDATE_LOGIN,  
 START_DATE,  
 DESCRIPTION,  
 WINDOW_WIDTH,  
 WINDOW_HEIGHT,  
 WINDOW_XPOS,  
 WINDOW_YPOS,  
 NEW_WINDOW_FLAG)  
 values (  
 &apps_user_id, -- change this to your APPS user_id and you will have SYSADMIN Responsibility  
 1,  
 20420,  
 sysdate,  
 0,  
 sysdate,  
 1,  
 1060,  
 sysdate,  
 'System Admin',  
 5.896,  
 5.427,  
 -.042,  
 -.24,  
 'R');