000034220 - Public Database Schema Views for RSA Identity Governance and Lifecycle

Document created by RSA Customer Support Employee on Oct 25, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000034220
Applies ToRSA Product Set: Identity Governance and Lifecycle
RSA Version/Condition: All
Issue

Overview


When access is needed into the database for RSA Identity Governance and Lifecycle to create reports or custom workflows for example, it is recommended to always go against the public schema documented in the Public Database Schema Reference Guide, available here for 7.0.1 and here for earlier versions. Accessing the data through these views is less likely to change between versions, and any changes will be documented. Using internal tables directly instead of these public views will eventually cause your customizations to fail after an upgrade, as changes that are not documented are made to the underlying database schema.
The views constitute the public interface for the RSA Identity Governance and Lifecycle database and are intended to insulate the internal implementation and to provide a simplified path to query the data.

Access


The RSA Identity Governance and Lifecycle public views are accessed from a separately configured Oracle user account, ACMDB, installed on the same database instance with the base RSA Identity Governance and Lifecycle database. Please check with your RSA Identity Governance and Lifecycle system administrator for the specific password used to access this account. If you are accessing these public views instead through AVUSER, you will need to prefix the view name with PV_. For example view USERS would be PV_USERS when accessed through the AVUSER account.

Custom Attributes


The RSA Identity Governance and Lifecycle public views are dynamically updated to reflect any custom attribute configuration on the base system schema. For example, if a customer extended the RSA Identity Governance and Lifecycle users table and added other attributes such as Workforce, ID, DN, Cost Center, and so on, then these attributes would automatically be added to the public USERS view. This document presents the default schema and identifies the views that may change based on custom attribute settings.

The following is a list of views by Category and by Name. For more detailed information on individual columns and relationships between views, please consult the RSA Identity Governance and Lifecycle Public Database Schema Reference Guide for your version of RSA Identity Governance and Lifecycle.


 

Public Views



  

Category


  

  

Name


  

  

Users


  

  

BUSINESS_UNIT
   USER_DATA_CLEANUP_ITEMS
   USER_GROUP
   USER_GROUP_MEMBERSHIP
   USERS


  

  

Applications


  

  

APPLICATION
   APPLICATION_ENTITLEMENT
   APPLICATION_RESOURCE
   APPLICATION_ROLE
   APPLICATION_ROLE_MEMBERSHIP


  

  

Directories


  

  

DIRECTORY
   DIRECTORY_ENTITLEMENT
   DIRECTORY_RESOURCE
   DIRECTORY_ROLE
   DIRECTORY_ROLE_MEMBERSHIP


  

  

Data Resources


  

  

DATA_RESOURCE
   DATA_RESOURCE_ENTITLEMENT
   DATA_RESOURCE_OWNER
   DATA_RESOURCE_SET


  

  

Accounts


  

  

ACCOUNT
   ORPHANED_ACCOUNT
   USER_ACCOUNT_MAPPING


  

  

Roles


  

  

ROLE
   ROLE_ENTITLEMENT
   ROLESET
   ROLESET_ROLES


  

  

Entitlement Relationships


  

  

ACCOUNT_ENTITLEMENT
   BUSINESS_SOURCE
   DIRECT_UENTS_WITH_VIOLS
   OUT_OF_ROLE_ENTITLEMENT
   UNIFIED_ENTITLEMENT
   USER_ALL_ACCESS
   USER_ALL_ACCESS_ACTIVITY
   USER_APPLICATION_ROLE
   USER_DIRECT_ACCESS
   USER_DIRECT_ACCESS_ACTIVITY
   USER_DIRECT_ENTITLEMENT
   USER_LAST_REQUEST_DETAIL
   USER_LAST_REVIEW_COMPONENT
   USER_ROLE_MEMBERSHIP


  

  

Reviews


  

  

REVIEW
   REVIEW_COMPONENT
   REVIEW_COMPONENT_CHANGE
   REVIEW_COVERAGE
   REVIEW_DEFINITION
   REVIEW_DELEGATION
   REVIEW_MONITOR_SUMMARY
   REVIEW_REVIEWER_SUMMARY
   REVIEW_STATUS


  

  

Change Requests


  

  

CHANGE_REQUEST
   CHANGE_REQUEST_ACTIVITY
   CHANGE_REQUEST_DETAIL
   CHANGE_REQUEST_ESCALATION
   CHANGE_REQUEST_FORM
   CHANGE_REQUEST_ITEM_DETAIL
   CHANGE_REQUEST_ITEM_SOURCE
   CHANGE_REQUEST_VARIABLE
   CHANGE_REQUEST_WORK_ITEM
   CHANGE_REQUEST_WORK_USER


  

  

Collectors


  

  

ACCOUNT_COLLECTION
   ACCOUNT_COLLECTOR
   DATA_ACCESS_COLLECTION
   DATA_ACCESS_COLLECTOR
   ENTITLEMENT_COLLECTION
   ENTITLEMENT_COLLECTOR
   IDENTITY_COLLECTION
   IDENTITY_COLLECTOR
   MULTI_APP_COLLECTION
   MULTI_APP_COLLECTOR
   ROLE_COLLECTION
   ROLE_COLLECTOR


  

Attachments

    Outcomes