user creation in 10g

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 20 07:05:12 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect system;
Enter password:
Connected.
SQL> create user identified by ;

User created.

SQL> grant create session to ;

Grant succeeded.


SQL> grant all privileges to ;

Grant succeeded.

SQL> connect
Enter password:
Connected.

Example:-
SQL> connect system;
Enter password:
Connected.
SQL> create user VES identified by SYCS;

User created.

SQL> grant create session to VES;

Grant succeeded.


SQL> grant all privileges to VES;

Grant succeeded.

SQL> connect VES
Enter password:
Connected.