Query to add SysAdmin responsibility to a user

The following query adds the System Administrator (SYSADMIN) responsibility to a user. The query needs to be run by APPS.

In the following example, I used 'PSHARMA' as my username.

-------------------------------------------------------------------------------

-- Query to add SYSADMIN responsibility to a user, using FND_USER_PKG.ADDRESP

-------------------------------------------------------------------------------

BEGIN

  

   FND_USER_PKG.ADDRESP(

      USERNAME        =>  'AMOHSIN',              -- 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;