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;
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;