Home / APPS DBA / 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;

........Subsribe OracleSolutions.pk........
OracleSolutions.pk is exclusively meant to guide the newbies to Learn and Share.

About oracle.solutions

Check Also

JSP error Request URI:/OA_HTML/RF.jsp java.lang.NoClassDefFoundError

ERROR JSP Error: Request URI:/OA_HTML/RF.jsp Exception: java.lang.NoClassDefFoundError JSP Error: Request URI:/OA_HTML/AppsLocalLogin.jsp Exception: java.lang.NoClassDefFoundError More from …

Leave a Reply