AnsweredAssumed Answered

User Entitlement View

Question asked by William May on Mar 7, 2019

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