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.
Start SQL*Plus or SQL*Plus Worksheet.
Log on as
SYSTEM and connect as
SYSDBA.
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> create user "TOM" IDENTIFIED BY "ORACLEPASSWORD";
SQL> grant connect, resource to "TOM";