BEGIN
FND_USER_PKG.ADDRESP
('SANDEEP_SHARMA',
'SYSADMIN',
'SYSTEM_ADMINISTRATOR',
'STANDARD',
'Add Sysadmin Responsibility to A user from Backend',
SYSDATE,
SYSDATE + 1000
);
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