How to reset EDIT/EXEC super users in autosys_secure

book

Article ID: 17447

calendar_today

Updated On:

Products

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

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

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

    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