$ su oracle $ sqlplus / as sysdba CREATE USER odb_test IDENTIFIED BY odb_test DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; GRANT CREATE TABLE, CREATE SEQUENCE, CREATE TRIGGER, CREATE SESSION, UNLIMITED TABLESPACE TO odb_test;