Create a user in Oracle and set the permission _ basic cmd

 

Create a user in Oracle and set the permission _ basic cmd

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>