create user &username identified by &username default tablespace 
users temporary tablespace temp;
grant connect, resource, create table, create view, unlimited tablespace 
to &username;