gistfile1.txt

$ sqlplus

SQL*Plus: Release 11.2.0.2.0 Production on Thu Apr 7 20:22:46 2011

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

Enter user-name: <your username here>
Enter password: <your password here>

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> CONNECT / as sysdba
Connected.
SQL> CREATE USER <new_user_name> IDENTIFIED BY "<password>" 
DEFAULT TABLESPACE "<desired_tablespace>" 
TEMPORARY TABLESPACE temp;

User created.

SQL> GRANT CONNECT, RESOURCE TO <new_user_name>;

Grant succeeded.

SQL> GRANT DBA TO <new_user_name>;

Grant succeeded.

SQL> ALTER USER <new_user_name> QUOTA UNLIMITED ON <desired_tablespace>;

User altered.

SQL> exit