Prepare the RDBMS

You must complete the tasks listed in this section before you configure the RDBMS for user monitoring. These tasks must be performed by a database administrator following instructions in your RDBMS documentation.

  • Install the RDBMS.

    The RDBMS does not need to be on the same server as the user monitoring application.

  • Create a user for user monitoring who has privileges to create, modify, and drop database objects, including tables, sequences, functions, constraints, procedures, and indexes.

  • Create a database to be used for user monitoring. Set the Database Collation property to Case Insensitive.

    Use the default collation for your RDBMS:

    MS SQL Collation = SQL_Latin1_General_CP1_CI_AS
    PostgreSQL Collation = English_United States.1252
    Oracle 11g and 12c

    NLS_SORT = BINARY

    NLS_CHARACTERSET = WE8MSWIN1252

    NLS_TERRITORY = AMERICA

    NLS_LANGUAGE = AMERICAN

  • Create a schema to be used for user monitoring. The schema must be owned by (or created by) the user you created for user monitoring.