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