How to recreate AutoSys userid in Oracle

Products

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

Issue/Introduction

Description:

The document deals with the steps to recreate the autosys userid in Oracle if it was dropped by mistake after the autosys install.

Solution:

Following are the steps to recreate the autosys user in Oracle with all its permissions.

Login to Oracle Server via sqlplus using the sys user and then execute the following commands :-

CREATE USER $AUTOSYS_USER PROFILE DEFAULT IDENTIFIED BY $AUTOSYS_PASS
DEFAULT TABLESPACE $TBLSPDATA_NAME ACCOUNT UNLOCK;
GRANT 'CONNECT' TO $AUTOSYS_USER;
GRANT $UJOADMIN TO $AUTOSYS_USER;
 
Defaults :-  $AUTOSYS_USER = autosys
                      $TBLSPDATA_NAME = AEDB_DATA
                      $UJOADMIN = ujoadmin

Environment

Release:
Component: ATSYS