Hi sanga,

1) Log into sqlplus using system/manager(default password) to the database.

2) CREATE USER USR1 IDENTIFIED BY PASSWD
DEFAULT TABLESPACE TS_USERS
TEMPORARY TABLESPACE TS_TEMP;

3) GRANT CONNECT, RESOURCE TO USR1


If you want the user to create objects on the other tablespaces , then give him his quota on the other ts as

alter user usr1
quota 50M on ts_users2
;


If you want the user to change his password on his first login then

alter user usr1
password expire;

If you want to drop the user, along with the objects created by him

drop user usr1 cascade;

Hope this helps
Badrinath