Create a NEW USER in FTAE

Create an Oracle USER

• Login to the desired Environment and Execute the following Statements (USER_NAME is the User Name) and (PASSWORD = Initial Password)

• CREATE USER USER_NAME IDENTIFIED BY PASSWORD;

• GRANT CONNECT TO USER_NAME;

• GRANT CREATE SESSION TO USER_NAME;

• GRANT FTAE_FULL_UPDATE TO USER_NAME;

• Create new RECORD for USER in FTAE_SEC_USERS (Copy a similar user with desired privileges)

• To Change Oracle Password ALTER USER USER_NAME IDENTIFIED BY NEWPASSWORD;

• To Unlock USER ALTER USER USER_NAME IDENTIFIED BY NEWPASSWORD ACCOUNT UNLOCK;