To create a user in the database, you use the CREATE USER statement.
The simplified syntax for the CREATE USER statement is as follows:
CREATE USER user_name IDENTIFIED BY password
[DEFAULT TABLESPACE default_tablespace]
[TEMPORARY TABLESPACE temp_tablespace];
where
If you omit a default tablespace, the default SYSTEM tablespace is used.
Tablespaces are used by the database to separate objects.
temp_tablespace specifies the default tablespace where temporary objects are stored.
If you omit a temporary tablespace, the default SYSTEM tablespace is used.