Hi! Has anyone implemented ESS/MSS and Org chart functionality in Portal and LS 9?
Because of the access required on the Employee table, I'm having issues with core users (i.e. AP processor) and the ability to "drill" on an employee's information which shouldn't be available to anyone but the employee (salary).
I've tried field level security on the Employee and PAEmployee tables, but the performance is really bad, to the extent of not returning data.
Any suggestions??
I'm assuming your user has the "access" flag set to Y, which essentially opens up IOS data security to being able to access data for any employee. Prior to LSF9 and 9.0 security, this resulted in a "fatal flaw" in how IOS (and therefore SEA) apps implemented security. The problem was that users need to wear multiple hats, i.e. you can be a manager, an employee, a requester, an approver, and a vendor--all of which requires appropriate security, and which breaks down with IOS security. Hence the addition of the Access flag, which basically says "let the user see any data within their designated LAUA security class, and ignore the restrictions added be IOS". While this opening up of security is obviously required for anyone working in HR, if you do it for other user (an example being req approval--if you have access set to N and you are both a requester and an approver, you can't see/approve any reqs!) You end up with your situation. John Henley