Login to SYSADMIN user
++++++++++++++++++
Creation of User
Navigation –
System Administrator -> Security -> User -> Define -> enter new user name & password
+++++++++++++++++++++++++++++++++++++++++++
Login to apps user
SQL>
BEGIN
FND_USER_PKG.ADDRESP(
USERNAME =>
'MANJURED',
RESP_APP =>
'SYSADMIN',
RESP_KEY =>
'SYSTEM_ADMINISTRATOR',
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