SQL Query to Assign System Administrator Responsibility
--------------------Query Start---------------------------------
BEGINFND_USER_PKG.ADDRESP(
USERNAME => &USER_NAME, -- 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;
--------------------Query End---------------------------------
No comments:
Post a Comment