Oracle: HOW TO CREATE USER AND GIVE GRANTS
create user [username] identified by [password] default tablespace [tablespace name which has free space acc to statement 8] quota unlimited on [same tablespace name];
create user [username] identified by [password] default tablespace [tablespace name which has free space acc to statement 8] quota unlimited on [same tablespace name];