How to change Autosys database password?

Products

• CA Workload Automation AE - Scheduler (AutoSys)
• Autosys Workload Automation

Issue/Introduction

Due to security policies established in our company, we are asked to periodically change passwords for Autosys accounts 

AEDBADMIN
AUTOSYS   

Please provide instructions how to perform these tasks. 

Environment

Component : CA Workload Automation AE (AutoSys)

Release : All Supported Versions

 

Resolution

There are 2 possible solutions for configuring AutoSys to connect to AEDB:

Either you use the “aedbadmin” database user or you use the “autosys” database user.

In your “config.XXX” file under $AUTOUSER folder, you will find the database user configured for connection to AEDB.

Example: 

$ cd $AUTOUSER

$ vi config.PRD

.......

# Keyword: DBAccess=username/password
#
# Defines  the user name and password (in encrypted format) used by
# the scheduler and  application server to connect to the database.
# The database user name  and  password is  defined  during  the CA
# Workload Automation AE installation.
#
DBAccess=autosys/2B4A60C0D02773E4E3FF7452033F9D3C

 

In the example above "autosys" user in configured as the "database user" to connect to AEDB. 

 

The “password” for the "database user" is configured by using the “autosys_secure” utility.

 

Example:

$ autosys_secure

CA WAAE Security Utility

Please select from the following options:

[1] Revert to NATIVE instance security.

[2] Manage CA EEM security settings.

[3] Change database password. < =====

[4] Change remote authentication method.

[5] Manage users.

[6] Get encrypted password.

[0] Exit CA WAAE Security Utility.

> 3

Enter current password: ....



So when you need to modify the “database user’s password, you can use “autosys_secure” utility as above to change the password at the required frequency.

Please also verify in case you have any “scripts” using the “autosys” database user and password, you will need to update those scripts as well.