Skip Navigation Links | |
Exit Print View | |
Oracle Identity Analytics 11gR1 Database Administrator's Guide |
This chapter describes the miscellaneous tables that are used in Oracle Identity Analytics.
|
|
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.
PK_CONFIGURATIONS on column CONFIGURATIONKEY
None
None
|
|
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.
PK_EMAIL_TEMPLATES on column ID
None
None
|
|
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.
PK_PASSWORD_DICTIONARY on column WORD
None
None
|
|
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.
PK_SEQUENCES on column SEQUENCENAME
None
None
|
None
The PARAMETERS table stores parameters of different types that are used by Oracle Identity Analytics. This table is used to store miscellaneous data.
None
None
None