How to reset EDIT/EXEC super users in autosys_secure

Products

• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

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?

Environment

Workload Automation AE 11.x/12.x

Resolution

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