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];