The Miscellaneous Tables

This chapter describes the miscellaneous tables that are used in Oracle Identity Analytics.

CONFIGURATIONS Table

Structure

CONFIGURATIONS PK CONFIGURATIONKEY CONFIGURATIONXML

Index

Index PK Unique Keys PK_CONFIGURATIONS      ✓ Yes CONFIGURATIONKEY

Description

Oracle Identity Analytics configuration details are defined in XML files, which are stored in the Oracle Identity Analytics database in the CONFIGURATIONS table. The CONFIGURATIONKEY column is a unique key that identifies the various configurations, while the CONFIGURATIONXML column points to the various configuration files that handle the connections to the provisioning system.

Primary Keys

PK_CONFIGURATIONS on column CONFIGURATIONKEY

Foreign Keys

None

Indexes

None

EMAIL_TEMPLATES Table

Structure

EMAIL_TEMPLATES PK ID NAME DESCRIPTION SENDERNAME EMAILFROM EMAILTO EMAILCC EMAILBCC SUBJECT HTMLENABLED BODY REPORTS_ALLOWED CREATEUSER UPDATEUSER CREATEDATE UPDATEDATE

Index

Index PK Unique Keys PK_EMAIL_TEMPLATES      ✓ Yes ID

Description

The EMAIL_TEMPLATES table is used to store the email definitions utilized by different Oracle Identity Analytics modules. Each template is identified by a distinct ID. The REPORTS_ALLOWED field specifies whether the email would have an Oracle Identity Analytics report as an attachment. Additional information such as CREATEUSER, UPDATEUSER, CREATEDATE, and UPDATEDATE are provided for audit purposes.

Primary Keys

PK_EMAIL_TEMPLATES on column ID

Foreign Keys

None

Indexes

None

PASSWORD_DICTIONARY Table

Structure

PASSWORD_DICTIONARY PK WORD

Index

Index PK Unique Keys PK_PASSWORD_DICTIONARY      ✓ Yes WORD

Description

Oracle Identity Analytics security supports user password validation. If enabled, one option checks the PASSWORD_DICTIONARY table for a list of prohibited words and, if a match is found, the password is not allowed. This validation is not case sensitive.

Primary Keys

PK_PASSWORD_DICTIONARY on column WORD

Foreign Keys

None

Indexes

None

SEQUENCES Table

Structure

SEQUENCES PK SEQUENCENAME CURRENTVALUE

Index

Index PK Unique Keys PK_SEQUENCES      ✓ Yes SEQUENCENAME

Description

The SEQUENCES table holds the last IDs used for domain objects in the Oracle Identity Analytics tables. These IDs are stored in the CURRENTVALUE field.

Primary Keys

PK_SEQUENCES on column SEQUENCENAME

Foreign Keys

None

Indexes

None

PARAMETERS Table

Structure

PARAMETERS PARAMETER_NAME INTEGER_VALUE LONG_VALUE DATE_VALUE BOOLEAN_VALUE TEXT_VALUE

Index

None

Description

The PARAMETERS table stores parameters of different types that are used by Oracle Identity Analytics. This table is used to store miscellaneous data.

Primary Keys

None

Foreign Keys

None

Indexes

None