Monday, February 21, 2022

How to add system administrator responsibility from backend || How to add system administrator responsibility to user from backend

 How to add system administrator responsibility from backend || How to add system administrator responsibility to user from backend


BEGIN

  

   FND_USER_PKG.ADDRESP(

      USERNAME        =>  'MMANOHAR',              -- Add your User Name Here

      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;