Create user in oracle
SYNTAX :
CREATE USER <USER_NAME> IDENTIFIED BY <PASSWORD> DEFAULT TABLESPACE <TABLESPACE_NAME>
TEMPORARY TABLESPACE <TEMP_TABLESPACE>;
Eg:
CREATE USER SCOTT IDENTIFIED BY oracle#41234 DEFAULT TABLESPACE users
TEMPORARY TABLESPACE TEMP;
-TO
CREATE an USER,
which will prompt
FOR NEW password upon login:
CREATE USER SCOTT IDENTIFIED BY oracle#41234 DEFAULT TABLESPACE users
TEMPORARY TABLESPACE TEMP password expire;