Add Responsibility to USER using pl/sql

最新推荐文章于 2019-01-17 14:51:29 发布

田攀

最新推荐文章于 2019-01-17 14:51:29 发布

阅读量2.5k

点赞数

本文链接：https://blog.csdn.net/pan_tian/article/details/8206988

版权

Scripts 专栏收录该内容

74 篇文章 0 订阅

订阅专栏

begin
fnd_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;