Setting Up Users for Silk Test Workbench in Oracle

This section provides instructions for creating users and granting connection rights for users. This procedure is necessary when using either Oracle OS authentication or Oracle database authentication. Separate instructions are provided for each type of authentication.

Oracle OS Authentication

Users must be created in such a way that Oracle knows they are authenticated via a DOMAIN controller.

Important:

When setting up users for Silk Test Workbench in Oracle, a schema must be also created to house the actual tables in addition to the remotely authenticated users. The schema is not domain authenticated, but is password authenticated. For more information, see Creating the Password Authenticated Schema.

Users must be created within a Windows NT domain. Refer to your Microsoft Windows documentation for more information about using a Windows domain.

Users must be added to the ORA_DBA group. Use SQL*Plus or SQL*Plus Worksheet to create users. If you are not familiar with SQL*Plus, consult your Oracle documentation.

The user performing these steps must be a member of the ORA_DBA group and have SYSDBA privileges. To specify users that can access the Oracle database:

  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 "DOMAIN\USERNAME" IDENTIFIED EXTERNALLY, and grant connection rights for each user as "DOMAIN\USERNAME". Type DOMAIN\USERNAME in uppercase and between double quotation marks, where DOMAIN\USERNAME is each user’s domain and user name. For example:
    SQL> create user "NT-DOMAIN\JEFF" IDENTIFIED EXTERNALLY;
    SQL> grant connect, resource to "NT-DOMAIN\JEFF";
    Note: SELECT_ANY_SEQUENCE and SELECT_CATALOG_ROLE must also be granted to the user. For example:
    SQL> grant select any sequence to "JEFF";
    SQL> grant select_catalog_role to "JEFF";
    Microsoft operating systems return the DOMAIN\USERNAME when the user is queried. If this does not match what is defined in the database, NT authentication will fail with ORA-1017.
  4. Test that Windows NT authentication is set up correctly by connecting to the database via SQL*Plus. Type a "/" for the user name. Leave the Password field blank, and enter the host string appropriately. Click OK. If you are able to log on, Windows NT authentication is working properly.

Oracle Database Authentication

Important: When setting up users for Silk Test Workbench in Oracle, a schema must also be created to house the actual tables in addition to the remotely authenticated users. The schema is password authenticated. For more information, see Creating the Password Authenticated Schema.

Use SQL*Plus to create users. If you are not familiar with SQL*Plus, consult your Oracle documentation. The user performing these steps must be a member of the ORA_DBA group and have SYSDBA privileges.

To specify users that can access the Oracle database:

  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 DOMAIN\USERNAME is each user’s user name. For example:
    SQL> create user "JEFF" IDENTIFIED BY "ORACLEPASSWORD";
    SQL> grant connect, resource to "JEFF";
    Note: SELECT_ANY_SEQUENCE, SELECT_CATALOG_ROLE, and SELECT_ANY_DICTIONARY must also be granted to the user. For example:
    SQL> grant select any sequence to "JEFF";
    SQL> grant select_catalog_role to "JEFF";
    SQL> grant select any dictionary to "JEFF";