Hi,

I need to enter SQL to tab Custome Security in Security Profile that will bring to the result:
Show only people with Location=XYZ (no other limitation such as BU, ORG etc.)
1.What is the correct SQL?
2. At the head of the screen- Should I restrict View Empl, CWK etc. ?

Thanks,
Ilanit

Hi there,

You'll need to set the custom security to Restrict the people visible to each user using this profile. The code that we have used here is ASSIGNMENT.location_id = xxx

This will then restrict to that particular location.

The View Employees has been set to Restricted as has the View Contacts. The remaining person types have been set to None as we do not want to see any of this information in the particular profile.

Hope this helps

Marina