Creating a user in Oracle 10g

Create user Username Identified by Password Default Tablespace Tablespacename temporary tablespacename account unlock;

Grant connect, resource username;

Commit;