Friday, May 27, 2016

SQL Query to Assign System Administrator Responsibility

SQL Query to Assign System Administrator Responsibility 

--------------------Query Start---------------------------------
BEGIN

   FND_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