Is there a less expensive view to call than V_USER_EXPLICIT_ENTITLEMENTS?
This select is taking over 15 minutes in my environment:
SELECT Entitled_ID,
Entitlement_ID
FROM AVUSER.V_USER_EXPLICIT_ENTITLEMENTS
WHERE ENTITLEMENT_TYPE='ApplicationRole'
Thanks,
Bill
7.0.2 P07
ah, does this work actually?
RSA IGL Services 101: Reports - Locating ALL App-Roles in the Public DB