BEGIN
FND_USER_PKG.ADDRESP
('YOUR_USERNAME',
'SYSADMIN',
'SYSTEM_ADMINISTRATOR',
'STANDARD',
'Add Sysadmin Responsibility to A user from Backend',
SYSDATE - 1,
SYSDATE + 99
);
COMMIT;
DBMS_OUTPUT.PUT_LINE ('Responsibility Added Successfully');
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.PUT_LINE ( ' Sys Admin Resp cannot be added: '
|| SQLCODE
|| SUBSTR (SQLERRM, 1, 100)
);
END;
FND_USER_PKG.ADDRESP
('YOUR_USERNAME',
'SYSADMIN',
'SYSTEM_ADMINISTRATOR',
'STANDARD',
'Add Sysadmin Responsibility to A user from Backend',
SYSDATE - 1,
SYSDATE + 99
);
COMMIT;
DBMS_OUTPUT.PUT_LINE ('Responsibility Added Successfully');
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.PUT_LINE ( ' Sys Admin Resp cannot be added: '
|| SQLCODE
|| SUBSTR (SQLERRM, 1, 100)
);
END;
No comments:
Post a Comment