Overview of Public Database Schema Views in RSA Identity Governance & Lifecycle
Originally Published: 2016-10-17
Last Modified: 2022-06-20
Article Number
Applies To
RSA Version/Condition: All
Issue
Overview
When creating Reports or custom Workflows in RSA Identity Governance & Lifecycle, the recommendation is to always use the Public Schema Views documented in the RSA Identity Governance and Lifecycle Public Database Schema Reference Guide for your version of RSA Identity Governance & Lifecycle. The views constitute the public interface to the RSA Identity Governance & Lifecycle database and are intended to insulate the internal implementation and to provide a simplified path to query the data.Accessing the data through these views is less likely to change between versions, and any changes are documented to plan your upgrade. Using internal tables directly instead of these public views can cause problems such as:
- Customizations failing after an upgrade due to changes to internal tables (which are intentionally not documented as they are proprietary.)
- Performance degradation due to table contention.
- Data corruption if internal tables are updated.
Resolution
Access
The RSA Identity Governance & Lifecycle public views are accessed from a separately configured Oracle user account, ACMDB, or in the case of Reports, AVDWUSER, installed on the same database instance as the base RSA Identity Governance & Lifecycle database schema (AVUSER). Check with your RSA Identity Governance & Lifecycle system administrator for the specific passwords used to access these accounts.
If you are designing custom workflows (Requests > Workflows > {Workflow-type tab} > Create Workflow > add SQL Select or SQL Execute node), refer to these tables in one of the following ways where public view USERS is shown as an example:
If you are designing custom workflows (Requests > Workflows > {Workflow-type tab} > Create Workflow > add SQL Select or SQL Execute node), refer to these tables in one of the following ways where public view USERS is shown as an example:
- ACMDB.USERS
- AVUSER.PV_USERS
If you are designing or modifying a report (Reports > Tabular/Chart > {Create Report} > Query tab), you are automatically connected the AVDWUSER database schema. Refer to these tables in one of the following ways where public view USERS is shown as an example:
- USERS
- ACMDB.USERS
- AVUSER.PV_USERS
Custom Attributes
The RSA Identity Governance & Lifecycle public views are dynamically updated to reflect any custom attribute configuration on the base system schema. For example, if custom user attributes are added (Admin > Attributes > User) such as Workforce, ID, DN, Cost Center, and so on, then these attributes would automatically be added to the public schema USERS view.
Public Views
Public Schema Views are documented in the RSA Identity Governance & Lifecycle Public Database Schema Reference Guide for your particular version.
Related Articles
Common User Schema Migration Dashboard Number of Views RSA Identity Governance and Lifecycle 7.0.2 upgrade fails during schema migration with 'ORA-06512: at "AVUSER.SIEM_INTEGRA… Number of Views Schema migration fails with ORA-01017 or ORA-28000 in RSA Governance & Lifecycle Number of Views ORA-20126 in Review Definition User Selection query with custom table in the AVCSUSER schema in RSA Governance & Lifecycle Number of Views How to query a public database schema table for Segregation of Duties (SOD) violations in RSA Identity Governance & Lifecycle Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Reporting on RSA Authentication Manager 8.x users with On-Demand Token, a fixed passcode or a hardware/software token assi… How to Download OTP Token Seed Files from myRSA Anomalix idGenius - SAML Relying Party Configuration - RSA Ready Implementation Guide RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
