1. Get unlimited access to documents by upgrading to Premium Membership.
  2. We are not accepting new members currently. If you would like to join, please contact us.
    Dismiss Notice
sanm23

How to add system administrator resposibility from backend 2011-03-29

How to add system administrator resposibility from backend

  1. sanm23
    BEGIN
    fnd_user_pkg.addresp ('SMUDALIAR','SYSADMIN','SYSTEM_ADMINISTRATOR','STANDARD','Add Responsibility to USER using pl/sql',SYSDATE,SYSDATE + 100);
    COMMIT;
    DBMS_OUTPUT.put_line ('Responsibility Added Successfully');
    EXCEPTION
    WHEN OTHERS
    THEN
    DBMS_OUTPUT.put_line ( ' Responsibility is not added due to ' || SQLCODE || SUBSTR (SQLERRM, 1, 100));
    ROLLBACK;
    END;