Create User in Oracle Database

For user creating you should create default TABLESPACE for this user or use current one.

You can create it follow:


1) First step you create tablespace for this.
create tablespace TEST1
datafile '/d01/oracle/oradata/test01.dbf'
size 100m;

2) Now you can create user:

CREATE USER test1 IDENTIFIED BY password

       DEFAULT TABLESPACE test1  

       TEMPORARY TABLESPACE temp

       QUOTA UNLIMITED ON test1;

3) After this you can give him permissions:

GRANT CREATE session, CREATE table, CREATE view, CREATE resource, 

      TO test1;