I have a new request that has me a bit confused as to how to move forward on. There is a project to build a data mart for our company HR data. I did do some searching but didn’t find anything that addressed my issues.
Security needs are:
Team leaders and their delegates only see their team (about 150 team leaders, 1500 employees also they have a tendency to change with some frequency) is the one that is causing me the most grief.
Senior HR sees everything (no brainer)
HR sees everything but HR employees I can handle that with row level security or a view and folder/class level security.
Is there a way to pass user actual ID through to the database instead of BOUSER?
No, there is no way to pass anything other than the BOUSER.
However, I solved this once before by building a simple table in the database that cross-referenced the BOUSER id with the actual id. It was pretty simple. We had a spreadsheet that held the data and used Informatica to suck the spreadsheet into the table every day.