Oracle Database Authentication

This topic provides instructions for creating users and granting connection rights when using Oracle database authentication. Prior to performing these steps, consider the following:

  • You must be a member of the ORA_DBA group and have SYSDBA privileges.

  • Use SQL*Plus or SQL*Plus Worksheet to create users. If you are not familiar with SQL*Plus, consult your Oracle documentation.

  • When setting up users for Silk Test Workbench in Oracle, create a schema to house the actual tables in addition to the remotely authenticated users. The schema is not domain authenticated, but is password authenticated.

  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 and system privileges as shown in the following example. 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:
    CREATE USER "JEFF" IDENTIFIED BY “ORACLEPASSWORD”;
    GRANT SELECT ANY SEQUENCE TO "JEFF";
    GRANT UNLIMITED TABLESPACE TO "JEFF";
    GRANT "CONNECT" TO "JEFF";
    GRANT "RESOURCE" TO "JEFF";
    GRANT "SELECT_CATALOG_ROLE" TO "JEFF";