TO ADD SYSTEM ADMINISTRATOR RESPONSIBILITY from backend DB:

Below query can be used to add (any)responsibility from backend database:

BEGIN
FND_USER_PKG.ADDRESP (
‘JUNAID’, — Username
‘SYSADMIN’, –application short name
‘SYSTEM_ADMINISTRATOR’, — Responsibility Key
‘STANDARD’, — Security Group Key
‘Sysadmin Responsibility added due to work’, –Description
sysdate, –Start date
null –End date
);
COMMIT;
DBMS_OUTPUT.put_line (‘Responsibility Added Successfully’);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line (
‘ Responsibility is not added due to ‘
|| SQLCODE
|| SUBSTR (SQLERRM, 1, 100)
);
ROLLBACK;
END;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s