How to recreate AutoSys userid in Oracle

Document ID : KB000049073
Last Modified Date : 14/02/2018
Show Technical Document Details

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