Oracle - Create User

If you wish to create a new user on the oracle database you would need to perform the following sql statement within SQLPLUS:

SQL> create user <username> identified by <password> default tablespace <tablespace name> temporary tablespace <tablespace name>

You then need to grant appropriate roles to the user for example, session, connect, resource:

SQL> grant connect to <username>;