Create user in oracle

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;