Create a NEW USER in FTAE

Owned by Sufyan Maghur
Last updated: Oct 12, 2023
1 min read

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;