How to reset EDIT/EXEC super users in autosys_secure

Document ID : KB000017447
Last Modified Date : 30/03/2018
Show Technical Document Details
Introduction:

Description:

I am no longer able to access autosys_secure to add any super user.

Is there a way to add the super user in autosys_secure?

Solution:

  1. Stop the scheduler and the application server, then run the below SQL commands
     
    1. delete from ujo_keymaster where hostid='SECURITY'; 
    2. Update aedbadmin.ujo_alamode set int_val=0 where type = 'JOB';
    3. Update aedbadmin.ujo_alamode set int_val=0 where type = 'EVT';
    4. Delete from ujo_alamode where type = 'SEC';
    5. Commit;
  2. Start the application server, then run "autosys_secure" to add your new super EDIT/EXEC users
  3. When done, exit from autosys_secure, then run again autosys_secure to ensure you have access to all the options in autosys_secure
  4. Start the scheduler
Instructions:
Please Update This Required Field