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 URL's to the "Public Database Schema Reference" documents are as follows:
IG&L 7.1:
https://community.rsa.com/docs/DOC-86130
IG&L 7.0.1 and 7.0.2:
https://community.rsa.com/docs/DOC-58736
Related Articles
How to perform bulk action on review items greater than 10k in RSA Via Lifecycle and Governance 6.9.1 Number of Views aveksaServer.log is not getting updated after applying 7.5.2 patch P04 in SecurID Governance & Lifecycle Number of Views Update version is not correct when attempting to perform an upgrade Number of Views Error "Request Entity Too Large" when upgrading RSA Authentication Manager from versions (8.2 SP1 up to 8.4 P13) to 8.5 Number of Views Pre-Upgrade Script Information Number of Views
Trending Articles
RSA Authentication Manager Patch Updates RSA Authentication Manager 8.9 Release Notes (January 2026) Unification is failing at step 8 on "AVUSER.ROLE_MANAGEMENT_PKG", line 2469 in RSA Governance & Lifecycle How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device How to Update the Root (Server) and Client Certificates in RSA Identity Governance & Lifecycle
Don't see what you're looking for?
