BusinessObjects Board

row level security

building reports webintelligence
#1

HI Guys,

We can apply object level security using BO designer.We have a requirement to have row level security. For example we have a prompts filter in our report. We want to restrict the user access on the list of LOV of that filter.
Prompt1 has LOV such as value1,value2. value3 etc. We want to create a restriction in such a way that user1 can see only value 1(if he got permission)but not value2 and value3 in the LOV list.

Is there any way to implement this?

thanks,
J WOOL

wood :nepal: (BOB member since 2006-06-05)

#2

A brief sketch:
Customize your LOV in Designer (do not forget to export it with your universe later) so that it will refresh automatically and that you are forcing a join to your security table (which maps BOUSER to allowed dimension values).

Andreas :de: (BOB member since 2002-06-20)

#3

Is there any good document i can refer to implement row level security?

wood :nepal: (BOB member since 2006-06-05)

#4

Here on B :mrgreen: B’s Download section you can find Steve Krandel’s presentation Using Designer to Implement Row-Level Security to get you started.

Andreas :de: (BOB member since 2002-06-20)