How to add system administrator responsibility from backend || How to add system administrator responsibility to user from backend
BEGIN
FND_USER_PKG.ADDRESP(
USERNAME => 'MMANOHAR', -- Add your User Name Here
RESP_APP => 'SYSADMIN', -- Apps Short Name
RESP_KEY => 'SYSTEM_ADMINISTRATOR', -- Responsibility Key
SECURITY_GROUP => 'STANDARD',
DESCRIPTION => NULL,
START_DATE => SYSDATE,
END_DATE => NULL);
COMMIT;
DBMS_OUTPUT.PUT_LINE('SYSADMIN Responsibility successfully added');
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('SYSADMIN responsibility not added due to ' || SQLERRM);
ROLLBACK;
END;
No comments:
Post a Comment