Monday, November 7, 2016

Query to add SysAdmin responsibility to a user

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;

No comments:

Post a Comment

Oracle Fusion - Cost Lines and Expenditure Item link in Projects

SELECT   ccd.transaction_id,ex.expenditure_item_id,cacat.serial_number FROM fusion.CST_INV_TRANSACTIONS cit,   fusion.cst_cost_distribution_...