sqlplus sys/password AS SYSDBA
To create user schema
create user username Identified by password DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON users;
You have to give grants to according to your requirement
GRANT CONNECT, CREATE TABLE TO username;
Reference :http://www.oracle-base.com/articles/misc/SchemaOwnersAndApplicationUsers.php
