Add Responsibility to USER using pl/sql

来源：互联网发布：淘宝新规店铺负责人编辑：程序博客网时间：2024/05/20 00:39

beginfnd_user_pkg.addresp(        ‘&User_Name’, /*Application User Name */        ‘&Responsablity_Application_Short_Name’, /*get from Query Below */        ‘&Responsibility_Key’,/*get from Query Below */        ‘&Security_Group’, /* Most of cases it is ‘STANDARD’ so you can hard code it */        ‘&Description’, /* Any comments you want */        ‘&Start_Date’, /* Sysdate From Today */        ‘&End_Date’ ); /* Sysdate + 365 Rights for Next One Year*/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;/

Sample:add Responsibility of “Receivables Manager” to User Jiltin

BEGIN        fnd_user_pkg.addresp (‘JILTIN’,‘AR’,‘RECEIVABLES_MANAGER’,‘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;

Related:Oracle Apps Script to create a new User Login Account