Hello,
I have the following setup to only allow users to edit employees that are IsExternal=1. Here is my SQL on it...
"uid_person in ( select uid_person from QER_VEditEmployee where uid_personhead = '%useruid%')
and ((IsExternal = 1) or (IdentityType = 'Service'))
Or
uid_person in ( select uid_person from person where ccc_deputymanager = '%useruid%' )
and ((IsExternal = 1) or (IdentityType = 'Service'))"
This does not restrict employees who are sponsor for IsExternal=0 if they look them up on white pages. When someone looks up someone they sponsor on the white pages they can navigate to Master Data and edit the employee. Is this suppose to restrict employees who go into webportal the ability to edit the Person record? Persons that are IsExternal=0 are loaded from HR and only should be managed by the sync from HR data.
I hope someone can help.
Thank you,
Lu
