How to assign SYSTEM ADMINISTRATOR Responsibility from backed
BEGIN
FND_USER_PKG.ADDRESP
(‘ASSIGNEE_USERNAME_HERE’,
‘SYSADMIN’,
‘SYSTEM_ADMINISTRATOR’,
‘STANDARD’,
‘Add Sysadmin Responsibility to A user from Backend’,
SYSDATE – 1,
SYSDATE + 99
);
COMMIT;
DBMS_OUTPUT.PUT_LINE (‘Sysadmin responsibility added Successfully’);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.PUT_LINE ( ‘ This responsibility cannot be added: ‘
|| SQLCODE
|| SUBSTR (SQLERRM, 1, 100)
);
END;
/
OR
BEGIN
FND_USER_PKG.ADDRESP(
USERNAME => 'ASSIGNEE_USER', -- User Name -- <change it>
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;
Comments
Post a Comment