Skip Navigation Links
Oracle Identity Analytics 11gR1 Database Administrator's Guide
Search Scope:
This Document
Entire Library
Oracle Identity Analytics 11gR1 Database Administrator's Guide
September 2010
Document Information
Preface
1. GlobalUsers Module
Tables in the GlobalUsers Module
GLOBALUSERS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
GLOBALUSER_ACCOUNTS TABLE
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
GLOBALUSER_ROLES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
GLOBALUSERSTATUSES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
2. Business Structure Module
Tables in the Business Structure Module
BUSINESSUNITS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
BU_GLOBALUSERS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
BU_ROLES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
BU_POLICIES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
BUHIERARCHY Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
BUSINESSUNITSTATUSES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
3. Resource Types Metadata Module
Tables in the Resource Types Metadata Module
NAMESPACES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
ATTRIBUTECATEGORIES Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
ATTRIBUTES Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
ATTRIBUTE_VALUES Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
ATTRIBUTE_VALUE_METADATA Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
ENDPOINTS Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
ENDPOINT_POLICIES Table
Structure
Indexes
Description
4. Accounts Module
Tables in the Accounts Module
ACCOUNTS Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
ACCOUNT_TYPES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
ACCOUNT_ATTRIBUTES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
ARC_ACCOUNT_ATTRIBUTES Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
ACCT_ATTR_HIER_NODES Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
5. Roles Module
Tables in the Roles Module
ROLES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
ROLEHIERARCHY Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
ROLE_VERSIONS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
ROLESTATUSES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
ROLE_TYPES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
ROLE_OWNERS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
ROLE_EXCLUSIONROLES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
ROLE_POLICIES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
6. Policies Module
Tables in the Policies Module
POLICIES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
POLICY_ATTR_HIER_NODES Table
Structure
Index
Description
Primary Key
Foreign Key
Indexes
POLICY_VERSIONS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
POLICY_ATTRIBUTES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
POLICY_EXCLUSIONPOLICIES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
POLICY_OWNERS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
7. Applications Module
Tables in the Applications Module
APPLICATIONS Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
APPLICATION_ATTRIBUTES Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
APPLICATION_ACCOUNTS Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
APPLICATION_OWNERS Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
APPLICATIONSTATUSES Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
8. Import and Export Module
Tables in the Import Export Module
IMPORT_RUNS Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
IMPORT_RUN_STEPS Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
IMPORT_VALIDATION_EXCEPTIONS Table
Structure
Description
Primary Keys
Foreign Keys
Indexes
EXPORT_RUNS Table
Structure
Index
Description
Primary Key
Foreign Key
Indexes
9. Event Listener Module
Tables in the Event Listener Module
EVENT_LISTENERS Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
EVENT_TRIGGER_DATA Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
OBJECT_MODIFICATIONS Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
10. Identity Certification Module
Tables in the Identity Certification Module
ID_CERTS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
IDC_CONFIGURATIONS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
IDC_USERS TABLE
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
ID_CERT_USERS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
IDC_ACCOUNTS Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
IDC_ACCOUNT_ATTRIBUTES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
IDC_ATTR_VALUES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
IDC_USER_ACCOUNTS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
IDC_USER_ACCT_ATTRS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
ID_ATTR_VAL_USERS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
ID_CERT_ATTR_VALUES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
IDC_ROLES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
ID_CERT_ROLES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
IDC_USER_ROLES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
IDC_POLICIES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
IDC_POLICY_ATTRIBUTES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
IDC_ROLE_POLICIES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
IDC_ROLE_POLICY_ATTRS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
REMEDIATION_CONFIG Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
11. Identity Audit Module
Tables in the Identity Audit Module
IDA_POLICIES Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
IDA_POLICY_VIOLATIONS Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
IDA_POLICY_VIOLATION_CAUSES Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
IDA_SCANS Table
Structure
Index
Description
Primary Key
Foreign Key
Indexes
IDA_POLICY_VIOLATIONS_TRAILS Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
IDA_POLICY_VIOLATION_PREVIEWS Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
IDA_VIOLATION_PREVIEW_CAUSES Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
12. Rule Engine Module
Tables in the Rule Engine Module
RULES Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
RULE_OWNERS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
RULE_SETS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
RULE_SET_RULES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
RULE_TYPES Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
RULE_VERSIONS Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
ROLE_MEMBERSHIP_RULE Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
ROLE_MEMBERSHIP_RULE_DATA Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
ROLE_MEMBERSHIP_RULE_SCANS Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
RM_RULE_SCAN_RESULTS Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
USER_BU_RULE_SCANS Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
USER_BU_RULE_SCAN_RESULTS Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
USER_BU_RULE_EXTENDED_ATTS Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
USER_APPLICATION_SCANS Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
USER_TRANSFERS Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
13. Workflow Module
Tables in the Workflow Module
OS_WFENTRY Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
OS_CURRENTSTEP Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
OS_HISTORYSTEP Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
OS_CURRENTSTEP_PREV Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
OS_HISTORYSTEP_PREV Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
OS_PROPERTYENTRY Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
APPROVAL_REQUESTS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
APPROVAL_REQUEST_HISTORY Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
ROLE_MATCHING_ANALYSIS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
14. Scheduling Module
Tables in the Workflow Module
OS_WFENTRY Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
OS_CURRENTSTEP Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
OS_HISTORYSTEP Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
OS_CURRENTSTEP_PREV Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
OS_HISTORYSTEP_PREV Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
OS_PROPERTYENTRY Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
APPROVAL_REQUESTS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
APPROVAL_REQUEST_HISTORY Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
ROLE_MATCHING_ANALYSIS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
15. Reporting Module
Tables in the Workflow Module
OS_WFENTRY Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
OS_CURRENTSTEP Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
OS_HISTORYSTEP Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
OS_CURRENTSTEP_PREV Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
OS_HISTORYSTEP_PREV Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
OS_PROPERTYENTRY Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
APPROVAL_REQUESTS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
APPROVAL_REQUEST_HISTORY Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
ROLE_MATCHING_ANALYSIS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
16. Security Module
Tables in the Security Module
RBX_USERS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
PROXY_ASSIGNMENTS Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
PROXY_RBACXROLE Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
RBX_ROLES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
PROXY_RBACXROLE Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
RBX_USER_RBX_ROLES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
RBX_ROLE_ACEGI_ROLES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
RBX_USER_RBX_ROLES_BU Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
RBX_AUTHORITIES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
ACL_OBJECT_IDENTITY Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
ACL_PERMISSION Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
RBX_ACL_CLASS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
RBX_ACL_ENTRY Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
RBX_ACL_OBJECT_IDENTITY Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
RBX_ACL_SID Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
RBX_AUDIT_ENTRIES Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
RBX_AUDIT_ENTRY_EXT_PROPS Table
Structure
Indexes
Description
Primary Keys
Foreign Keys
Indexes
17. Miscellaneous Tables
The Miscellaneous Tables
CONFIGURATIONS Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
EMAIL_TEMPLATES Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
PASSWORD_DICTIONARY Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
SEQUENCES Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes
PARAMETERS Table
Structure
Index
Description
Primary Keys
Foreign Keys
Indexes