The fastest and most practical way to create a user in Oracle

The fastest and most practical way to create a user in Oracle:

 

Step 1

Select the SQL plus shortcut (E:/Documents and Settings/all users/Start Menu/Program/Oracle-orahome92/Application Development/SQL plus.

Use the system's Default User Name (system) + password (manager) + host string (database name)

 

Step 2

SQL>
Create tablespace username datafile 'e:/Oracle/ora92/Network/admin/username. ora'
Size 10 m Reuse
Autoextend on next 5120 K
Minimum extent 512 K
Default storage (initial 512 K next 512 K minextents 1 maxextents 4096 pctincrease 1 );

 

SQL>
Create User Username identified by login password default tablespace username;

 

SQL>
Alter User Username quota unlimited on username;

 

SQL>
Grant connect, resource to user name;
 
SQL>
Connect user name/login password;