Custom criteria Person Security Profile- Restricted role users to search particular employees
Summary:
Hi,
By using Custom criteria Person Security Profile- we have Restricted role users to search particular employees, but role users are able to search restricted employee through me→ directory.
Any solution to restrict directory search as well.
Code of Person Security Profile-
(EXISTS
(SELECT 1 FROM PER_ALL_ASSIGNMENTS_M ASG,PER_PERIODS_OF_SERVICE PS,PER_ASG_RESPONSIBILITIES RES
WHERE ASG.ASSIGNMENT_TYPE IN('E','C','P','N')
AND ASG.EFFECTIVE_LATEST_CHANGE='Y'
AND TRUNC(SYSDATE) < ASG.EFFECTIVE_END_DATE
AND PS.PERIOD_OF_SERVICE_ID=ASG.PERIOD_OF_SERVICE_ID
AND (ASG.ASSIGNMENT_STATUS_TYPE IN ('ACTIVE','SUSPENDED') OR (ASG.ASSIGNMENT_STATUS_TYPE IN ('INACTIVE')