Skip Navigation Links | |
Exit Print View | |
Oracle Identity Analytics 11gR1 Database Administrator's Guide |
3. Resource Types Metadata Module
This chapter describes the tables that make up the Oracle Identity Analytics GlobalUsers module.
|
|
Users that are stored in the Oracle Identity Analytics Identity Warehouse are saved in the GLOBALUSERS table. Each user is known as a global user and identified by a unique GLOBALUSERKEY. This table stores basic information about every user in the USERNAME, FIRSTNAME, LASTNAME, and MIDDLENAME fields. There are also fields to save additional information about the user, including the user's address, email, phone, and various other custom fields. Because the user can be associated with a workflow, fields are provided to save the user's manager, business approver, and technical approver. A DELEGATE field is also present so that the user can specify a delegate. The STATUSKEY field contains the user's status. For audit purposes the table carries the account's creation date and update date, the user who created the account, and the name of the user who updated the account.
PK_GLOBALUSERS - primary key on column GLOBALUSERKEY
None
IX_GU_UNAME - non-unique index on column USERNAME
|
|
A Global user in Oracle Identity Analytics is associated with an account by associating the GLOBALUSERS and ACCOUNTS tables with a derived table, GLOBALUSER_ACCOUNTS. This table carries the ACCOUNTKEY and GLOBALUSERKEY.
PK_USER_ACCOUNTS - composite primary key on column GLOBALUSERKEY and ACCOUNTKEY
None
IX_GU_ACCTS_GUID - non-unique index on column GLOBALUSERKEY
IX_GLOBALUSER_ACCOUNTS_ACCOUNT - unique constraint on column ACCOUNTKEY
|
|
Each Global user can be associated with a role and this association is represented in a derived table, GLOBALUSER_ROLES. This table references tables GLOBALUSERS and ROLES using the GLOBALUSERKEY and ROLEKEY fields.
PK_GLOBALUSER_ROLES - composite primary key on columns GLOBALUSERKEY and ROLEKEY
None
IX_GU_ROLES_GUID - non-unique index on column GLOBALUSERKEY
IX_GU_ROLES_RID - non-unique index on column ROLEKEY
IX_GU_ROLES_RQSTART - non-unique index on column START_REQUEST_ID
IX_GU_ROLES_RQEND - non-unique index on column END_REQUEST_ID
|
|
Similar to the Business Unit, each user has a status associated with it. The GLOBALUSERSTATUSES table saves the possible statuses that can be associated with the globalusers. The actual 'status' is represented in the STATUSKEY and LABEL fields.
PK_GLOBALUSERSTATUSES - primary key on column STATUSKEY.
None
None