1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!
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;