|
Step 3: Create an Oracle User for SAMPLE Tablespace
- Create an Oracle user named wsdemo, with a password of wsdemo1, for the SAMPLE tablespace.
Using the Oracle command line interface, type:
- CREATE USER "WSDEMO" PROFILE "DEFAULT" IDENTIFIED BY "wsdemo1" DEFAULT TABLESPACE "SAMPLE" QUOTA UNLIMITED ON SAMPLE ACCOUNT UNLOCK;
- GRANT CONNECT TO WSDEMO;
Please see Oracle documentation for more information on GUI or command line options.
 
- Be sure to user all lower case letters to create the password, wsdemo1.
|