SQL Query to obtain directly assigned entitlements for a user
Originally Published: 2019-01-28
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 Enable Identity Confirmation Methods for a Risk-Based Authentication Policy Number of Views How a User Configures an Identity Confirmation Method Number of Views Troubleshoot 'User is not enrolled for identity confirmation methods' error Number of Views Intermittently SQL select node queries are seen in runtime in RSA Identity Governance & Lifecycle Number of Views
Trending Articles
RSA SecurID software token .sdtid file fails to import into RSA SecurID Software Token 5.0 for Windows RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device RSA Announces the Release of RSA MFA Agent 2.5 for Microsoft Windows How to Download OTP Token Seed Files from myRSA
Don't see what you're looking for?
