AnsweredAssumed Answered

Query to find members of a role

Question asked by Lakshman Varadharajan on Apr 24, 2017
Latest reply on Apr 25, 2017 by Venkata Ramana Reddy Kanaparthy

L&G 691 P18 (Aveksa)

  I need to write a query to find members (both direct and indirect) of roles.  I can get the direct memebers from the view pv_user_role_membership but how to get  indirect memebers as well. What tables i need to join.  Any help is really appreciated.

Outcomes