Creating the Password Authenticated Schema

To set up the password authenticated schema into which the Silk Test Workbench tables are stored, perform the following steps:

Note: The password authenticated schema should not be more than five characters in length because of Oracle character limitations in SQL series.
  1. Start SQL*Plus or SQL*Plus Worksheet.
  2. Log on as SYSTEM and connect as SYSDBA.
  3. Type commands to create each user as "USERNAME" IDENTIFIED BY "ORACLEPASSWORD", and grant connection rights for each user as "USERNAME". Type USERNAME in uppercase and between double quotation marks, where USERNAME is each user’s user name. For example:
    SQL> grant connect, resource to "TOM";