REM
REM DBAToolZ NOTE:
REM	This script was obtained from DBAToolZ.com
REM	It's configured to work with SQL Directory (SQLDIR).
REM	SQLDIR is a utility that allows easy organization and
REM	execution of SQL*Plus scripts using user-friendly menu.
REM	Visit DBAToolZ.com for more details and free SQL scripts.
REM
REM 
REM File:
REM 	a_cr8_admin_resp.sql
REM
REM <SQLDIR_GRP>APPS</SQLDIR_GRP>
REM 
REM Author:
REM 	Vitaliy Mogilevskiy (www.dbatoolz.com)
REM 
REM Purpose:
REM	<SQLDIR_TXT>
REM	Hacks APPS table FND_USER_RESPONSIBILITY
REM	adding System Admin responsibility to any user
REM	</SQLDIR_TXT>
REM
REM Usage:
REM	a_cr8_admin_resp.sql <APPS_USER_ID>
REM 
REM Example:
REM	a_cr8_admin_resp.sql 1425
REM
REM
REM History:
REM	MM-DD-RRRR	VMOGILEV	Created
REM
REM

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');