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.
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";