CREATE USER <USERNAME> IDENTIFIED BY <PASSWORD>;
GRANT CONNECT TO <USERNAME>;
GRANT CREATE SESSION TO <USERNAME> WITH ADMIN OPTION; 
GRANT UNLIMITED TABLESPACE TO <USERNAME>; 
GRANT RESOURCE TO <USERNAME>;