Display schema user details for Workload Automation AE (AutoSys) and the WebUI (WCC)

Products

• Autosys Workload Automation

Issue/Introduction

For auditing and administration purposes there is a need to be able to identify the database schema owners for the products Workload Automation AE (AutoSys) and the WebUI (WCC).

Environment

Workload Automation AE (AutoSys) and the WebUI (WCC) 12.x, 24.x

 

Resolution

To see schema owners:

 

For AE view the file $AUTOUSER/config.$AUTOSERV
 See the setting 
 EventServer_1=<dbname>:<schemaowner>,<port>,<hostname_or_address>

 

For WCC run the commands:
 $CA_WCC_INSTALL_LOCATION/bin/wcc_config.sh -u ejmcommander -p <###> --displaydb REPORTING
 and
 $CA_WCC_INSTALL_LOCATION/bin/wcc_config.sh -u ejmcommander -p <###> --displaydb MAIN

See the Schema User values in the above commands. 
Replace ejmcommander with your username/password that has WCC's commander privileges if you are not using the default internal user store.