Showing specific user to manager in ARS screen while request for any access (Add,Remove access)

[ARNAB86]

Hi Team,

I have the usecase like i will create specific user group and it has few users whose manager is A (example).

So the Manager only can see those users in ARS page specified in the user groups not others and create the request for Add Access, Remove Access etc for ActiveDirectory endpoint.

Please suggest the solution

Thanks

Arnab Pal

[rushikeshvartak]

Add Access Query as below under Endpoint 

WHERE STATUSKEY = 1 AND users.USERKEY IN (SELECT UGU.USERKEY FROM USERGROUP_USERS UGU JOIN USER_GROUPS UG ON UG.USERGROUPKEY = UGU.USER_GROUPKEY AND UG.USER_GROUPNAME = 'GROUPNAME')