4.2.1 Creating an Oracle User
You can create an Oracle user using the following script:
CREATE USER <oracle_user_name> IDENTIFIED BY <password> DEFAULT
TABLESPACE USERS TEMPORARY TABLESPACE TEMP QUOTA <quota_size>|UNLIMITED ON
USERS