Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Blog Post

How to add System administrator responsibility from backend

How to add System administrator responsibility from backend

Syntax:

fnd_user_pkg.addresp(username => v_user_name
,resp_app => ‘SYSADMIN’
,resp_key => ‘SYSTEM_ADMINISTRATOR’
,security_group => ‘STANDARD’
,description => ‘Auto Assignment’
,start_date => SYSDATE – 10
,end_date => SYSDATE + 1000);

 

Usage:

BEGIN

fnd_user_pkg.addresp (‘OPERATIONS’,’SYSADMIN’,’SYSTEM_ADMINISTRATOR’,’STANDARD’,

‘Add Sysadmin Responsibility to OPERATIONS 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 Posts
Write a comment