Oracle Basic command 2 Create user set permissions __oracle

C:/>sqlplus

Sql*plus:release 9.2.0.1.0-production on Saturday September 29 15:08:34 2007

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

Please enter user name: SYS as SYSDBA
Please enter password:

Connect to:
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 has created

Sql> Grant connect to TestUser;

The authorization was successful.

Sql> commit;

Submit completed.

sql> ALTER user testuser quota unlimited on users;

The user has changed.

Sql> commit;

Submit completed.
Sql> quit
From Oracle9i Enterprise Edition release 9.2.0.1.0-production
With the partitioning, OLAP and Oracle Data Mining options
Disconnect in 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, 2002, Oracle Corporation. All rights reserved.

Please enter user name: TestUser
Please enter the password: (enter PWD here)

Connect to:
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>