Skip Navigation Links | |
Exit Print View | |
Oracle Identity Analytics 11gR1 Database Administrator's Guide |
This chapter describes the tables that make up the Oracle Identity Analytics Accounts module.
|
|
The ACCOUNTS table carries the accounts imported from the various Resource Types. Every account carries the Domain Name, Endpoint, and Status of the account. Also for audit purposes information about the account's Creation Date and Update Date, as well as the User who created the account and the user under which the account was updated is also saved in Oracle Identity Analytics. Each time the base accounts are updated, the ATTR_VALUES_HASH column is updated to keep track of the 'changed' accounts from the new feed. The account is also listed under its particular Resource Types by associating with the Namespace table using the NAMESPACEKEY as the reference.
PK_ACCOUNTS - composite key on columns ACCOUNTKEY and NAMESPACEKEY
None
IX_ACCOUNTS_ACCOUNTKEY - non unique index on column ACCOUNTKEY
|
|
The different account types imported into Oracle Identity Analytics are listed under the 'ACCOUNT_TYPES' table. The following out-of-the-box account types are supported:
1. Provisioning account
2. High Privileged
3. Service Account
4. System Account
By default, all account types are set to 'Provisioning account' if not explicitly specified in the import process.
PK_ACCOUNT_TYPES on column ID
None
None
|
|
The ACCOUNTS table carries only the account name and the audit values for that particular account. The ACCOUNT_ATTRIBUTES table carries references to the various parent accounts, along with hierarchy information within an account. It references the ACCOUNTS and the ACCT_ATTR_HIER_NODES tables by using the columns ACCOUNT_ID and ACCT_ATTR_HIER_ID respectively. These references help pull up information from the accounts and reference them to a particular account parent-child relationship.
PK_ACCOUNT_ATTRIBUTES_T - primary key on column ID
None
IX_ACCOUNT_ATTRIBUTES_ACID - non-unique index on column ACCOUNT_ID
IX_ACCOUNT_ATTRIBUTES_PID - non-unique index on column PARENT_ID
|
|
The ARC_ACCOUNT_ATTRIBUTES table archives 'old/changed' account_attribute data from the ACCOUNT_ATTRIBUTES table whenever an account is changed/updated.
None
None
IX_ARC_ACCT_ATTRIBUTES_ACID - non-unique index on column ACCOUNT_ID
IX_ARC_ACCT_ATTRIBUTES_PID - non-unique index on column PARENT_ID
|
|
The ACCT_ATTR_HIER_NODES maintains hierarchy information between attributes of an account. It has a unique ID, a ROOT_ID, and a PARENT_ID representing the root nodes and parent nodes respectively in the hierarchy. The ATTRIBUTE_VALUE_ID is a reference key to the ATTRIBUTE_VALUES table that contains the actual values of the attributes in the accounts. UPDATE_DATE stores information in case of an account modification. The fields LFT and RGT are used to maintain hierarchy information as well.
PK_ACCT_ATTR_HIER_NODES - primary key on column ID
None
IX_ACT_ATT_HIER_AV_ID - non-unique index on column ATTRIBUTE_VALUE_ID
IX_ACT_ATTR_HIER_RID - non-unique index on column ROOT_ID
IX_ACT_ATTR_HIER_PID - non-unique index on column PARENT_ID