How to assign SYSTEM ADMINISTRATOR Responsibility from backed

BEGIN
FND_USER_PKG.ADDRESP
(‘ASSIGNEE_USERNAME_HERE’,
‘SYSADMIN’,
‘SYSTEM_ADMINISTRATOR’,
‘STANDARD’,
‘Add Sysadmin Responsibility to A user from Backend’,
SYSDATE – 1,
SYSDATE + 99
);
COMMIT;
DBMS_OUTPUT.PUT_LINE (‘Sysadmin responsibility added Successfully’);

EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.PUT_LINE (   ‘ This responsibility cannot be added: ‘
|| SQLCODE
|| SUBSTR (SQLERRM, 1, 100)
);
END;

/



OR


BEGIN
  
   FND_USER_PKG.ADDRESP(
      USERNAME        =>  'ASSIGNEE_USER',              -- User Name -- <change it>
      RESP_APP        =>  'SYSADMIN',                   -- Apps Short Name
      RESP_KEY        =>  'SYSTEM_ADMINISTRATOR',       -- Responsibility Key
      SECURITY_GROUP  =>  'STANDARD',
      DESCRIPTION     =>  NULL,
      START_DATE      =>  SYSDATE,
      END_DATE        =>  NULL);
  
   COMMIT;
  
   DBMS_OUTPUT.PUT_LINE('SYSADMIN Responsibility successfully added');
    
EXCEPTION
   WHEN OTHERS THEN
      DBMS_OUTPUT.PUT_LINE('SYSADMIN responsibility not added due to ' || SQLERRM);
      ROLLBACK;
END;

Comments

Popular posts from this blog