SQL Query to obtain directly assigned entitlements for a user
Originally Published: 2019-01-28
Last Modified: 2026-05-13
Article Number
Applies To
RSA Version/Condition: 7.x
Issue
Resolution
1) PV_USER_DIRECT_ACCESS
2) PV_USERS
Example queries:
(1) To display 'ent' type entitlement and total count for this entitlement of type 'ent', for all users:
select count(*), ENTITLEMENT_TYPE from PV_USER_DIRECT_ACCESS where ENTITLED_ID IN (Select ID from PV_USERS) group by ENTITLEMENT_TYPE;
(2) To display entitlement name and type of a specific user
select D.ENTITLED_TYPE, D.ENTITLEMENT_NAME, D.ENTITLED_ID as MEU_ID, u.first_name, u.last_name from PV_USER_DIRECT_ACCESS D, PV_USERS U where ENTITLEMENT_TYPE = 'ent' and ENTITLED_ID IN (Select ID from PV_USERS U where USER_ID = 'shiremath');
Notes
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.
The URL's to the "Public Database Schema Reference" documents are as follows:
Related Articles
Guidelines for writing Report Chart SQL Queries in RSA Identity Governance & Lifecycle Number of Views How to obtain more information about ORA-00060 errors in RSA Identity Lifecycle & Governance Number of Views Using Passage 3.2 for certificate based authentication; ERROR: MAP_API_FILE_ERROR Major: MAP -339 Number of Views How to run a SQL query for Authentication Manager 8.0 or 8.1 and write the output to a file for support 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?
