Create a user in Oracle and Set permissions

SQL * Plus: Release9.2.0.1.0

SQL * Plus: Release 9.2.0.1.0-Production on Saturday September 29 15:08:34 2007 Copyright (c) 1982,200 2, Oracle Corporation. Al

C: \> sqlplus

SQL * Plus: Release 9.2.0.1.0-Production on Saturday September 29 15:08:34 2007

Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.

Enter the User name: sys as sysdba
Enter the password:

Connect:
Oracle9i Enterprise Edition Release 9.2.0.1.0-Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0-Production

SQL> create user testuser identified by pwd default tablespace users Temporary T
ABLESPACE Temp;

User Created

SQL> grant connect to testuser;

Authorization successful.

SQL> commit;

Submitted.

SQL> alter user testuser quota unlimited on users;

The user has changed.

SQL> commit;

Submitted.
SQL> quit
From Oracle9i Enterprise Edition Release 9.2.0.1.0-Production
With the Partitioning, OLAP and Oracle Data Mining options
Disconnects from JServer Release 9.2.0.1.0-Production

C: \> sqlplus

SQL * Plus: Release 9.2.0.1.0-Production on Saturday September 29 15:11:37 2007

Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.

Enter the User name: testuser
Enter the password: (enter pwd here)

Connect:
Oracle9i Enterprise Edition Release 9.2.0.1.0-Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0-Production

SQL>

,