Friday, September 4, 2015

How to add SYSADMIN responsibility to a user like MANJURED

Login to SYSADMIN user
++++++++++++++++++
Creation of User

Navigation – 

System Administrator ->                                        Security ->                                                            User ->                                                                           Define ->                                             enter new user name & password 


+++++++++++++++++++++++++++++++++++++++++++
Login to apps user

SQL>

BEGIN
 
   FND_USER_PKG.ADDRESP(
      USERNAME        =>  'MANJURED',             
      RESP_APP        =>  'SYSADMIN',            
      RESP_KEY        =>  'SYSTEM_ADMINISTRATOR',
      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;

+++++++++++++++++++++++++++++++++++++++

No comments:

Post a Comment