BusinessObjects Board

Security and User creation

building semantic layer
#1

Hi,

I have a question regarding the security setup in BO 4.0.

We have a certain set of users and we need to restrict their access based on a column - country.
I have created the reports and we have a prompt on the country column.

Few users should have access only to the data for India, while few others should have access only to China etc.
If the user who has access only to India selects China in the prompt, it should display an error message.

Can someone please let me know where I should start off with implementing this security. What part of the security needs to be done at IDT level?

Thanks,
Komal

Komalo (BOB member since 2013-04-15)

#2

https://bobj-board.org/t/144279

https://bobj-board.org/t/147386

Row level security trick for instances:-
http://www.trustedbi.com/tag/security/

Mak 1 :uk: (BOB member since 2005-01-06)

#3

Hi,

Thanks for your response.

Is it possible to do the security settings without creating a security table in the database?
Can we do this directly in the Universe?

Thanks

Komalo (BOB member since 2013-04-15)

#4

Yes you can, using Manage Access Restrictions in the universe.
I would suggest, however, that managing this at the database side is what I would recommend, for the following reasons:-

:!: Universe level security can have the habit of being lost during promotions or upgrades.
:!: Universe level security has to be maintained across multiple universes, if you use them.
:!: You can leverage this security table to enforce this row level security consistantly across multiple applications, consistantly.

Mak 1 :uk: (BOB member since 2005-01-06)

#5

Thanks…
You are right, I will try the security table approach…

Komalo (BOB member since 2013-04-15)