CREATE USER <user_name>
IDENTIFIED BY <password>
 
-- for example: 
CREATE USER mike
IDENTIFIED BY abc123;
 
 
-- create a user with a password containing spaces,  
-- punctuation characters or other special chars
 
CREATE USER <user_name>
IDENTIFIED BY "<password>"
 
-- for example: 
CREATE USER mike
IDENTIFIED BY "my $pecial p#ssword";
 
 
 
-- create a user with access to a default tablespace
 
CREATE USER <user_name>
IDENTIFIED BY <password>
DEFAULT TABLESPACE <tablespace_name>;
 
-- for example: 
CREATE USER mike
IDENTIFIED BY abc123
DEFAULT TABLESPACE sales_dept;
 
 
 
-- create a user with access to a temporary tablespace 
 
CREATE USER <user_name>
IDENTIFIED BY <password>
TEMPORARY TABLESPACE <temporary_tablespace_name>;
 
-- for example: 
CREATE USER mike
IDENTIFIED BY abc123
DEFAULT TABLE sales_dept
TEMPORARY TABLESPACE scratchpad;
 
/*
Restrictions on Temporary Tablespace
 
The tablespace must be a temporary tablespace and must 
have a standard block size.
 
The tablespace cannot be an undo tablespace or a tablespace 
with automatic segment-space management.
*/
 
 
-- create user account and expire a the password
 
CREATE USER <user_name>
IDENTIFIED BY <password>
DEFAULT TABLESPACE <tablespace_name>
TEMPORARY TABLESPACE <temp_tablespace_name>
QUOTA <quota_amount> ON <tablespace_name>
PROFILE <profile_name>
PASSWORD EXPIRE;
 
-- for example: 
CREATE USER mike
IDENTIFIED BY abc123
DEFAULT TABLESPACE sales_dept
TEMPORARY TABLESPACE scratchpad
PASSWORD EXPIRE;