BusinessObjects Board

security set up

security Supervisor (4.x - 6.x)
#1

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?

We are using BO 5.1.6.

Mike Murray :us: (BOB member since 2005-12-23)

#2

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.

Steve Krandel :us: (BOB member since 2002-06-25)

#3

OK, sounds good but how does the table know who BOUSER is? We currently pass a shared password along with BOUSER.

Mike Murray :us: (BOB member since 2005-12-23)

#4

You build a self join on the table:

securitytable.username=@variable('BOUSER')

Check this out. It might help some.

Steve Krandel :us: (BOB member since 2002-06-25)