ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How to reset EDIT/EXEC super users in autosys_secure


Article ID: 17447


Updated On:


CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) Workload Automation Agent


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?


    Release: ATSYHA99000-11.3.6-Workload Automation AE-High Availability Option


    1. Stop the scheduler and the application server, then run the below SQL commands
      1. delete from aedbadmin.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 aedbadmin.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