Row level Security

[system]

I want to implement a row level security. I have report a and have 40 branches each user has to view his branch report only and some users can view multiple braches and some all the braches.can some one guide me how to setup the security here. I am using BO XI R2

---

ssrr007 (BOB member since 2007-09-10)

[system]

@siruvuri

I have 40 users for my report and each user has to view his branch report only and some users can view multiple braches and some all the braches.
can some one guide me how to setup the security here. Do I need to do it at the datamodel and universe level or at the report level?

Search here on BOB, you will get a bunch of posts discussing that. Here is one to get you started.

FAQ: Designer

How can I implement row level security? How to Implement Row-Level Security First – what is Row-Level Security? When you want to specify which rows of data each userid is permitted to retrieve from the database, based on some column of data, or combination of columns of data – that is row-level security. Row-level security can be implemented in BusinessObjects in several possible ways. If you have a tech support login, you can look at some of the techniques and the pros and cons …

---

zack (BOB member since 2007-08-02)

[SebastienGoiffon]

Hi,

As already said you can manage this using row level restrictions set within the Designer or directly within the database.

Regards
Sebastien

[system]

A combination of Row level security within designer with a database table to define the users and roles would be a good fit. It works good to maintain user rights.

---

Bhavin (BOB member since 2007-08-22)