Adding Super user breaks autosys_secure

Products

• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

After upgrade to AutoSys from 11.3.6 SP4 to SP8, when a super user is added, autosys_secure has only the last three options available.

The following queries need to executed to get all the options:

delete from ujo_keymaster where hostid='SECURITY';
update ujo_alamode set int_val=0 where type in ('JOB', 'EVT');
delete from ujo_alamode where type='SEC';
commit;

 

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

Resolution

The super user's user@host in the database must match the login user Id and host name that are picked up by autosys_secure.