Hi sanga,

Login in as sys or system the default password when you install oracle are as follows

sys -> change_on_install

system -> manager

Once you connect as the above user just type the following statements

create user username identified by password default tablespace user temporary tablespace temp;

grant connect,resource to username;


The second statement is used to give the user privilege to create objects in the tablespace user

Hope this helped

Regards