AnsweredAssumed Answered

User Entitlement View

Question asked by William May on Mar 7, 2019
Latest reply on Feb 17, 2020 by Jamie Pryer

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

Outcomes