More than one Row and Colum restrictions

[system]

Hi

The two different restrictions on Branch code and Product code has created and tried to apply the two restriction on a user, its taking up only one restriction.

How should i apply two different type of restriction on a single user…?

Regards

Siva.M

---

looksmee (BOB member since 2006-02-08)

[system]

Uh - you sure you’re using AND logic - how are you applying the restriction?

---

MikeD (BOB member since 2002-06-18)

[system]

Hi Mike

Thanks for your reply…

Have created one row level restriction on Branch code and associated couple of users on that and again created an another restriction on Product code and assigned the users. In one case, i needs to assign the both restriction to the user who should have the restriction on the Branch code and Product code and it should not done in the where statement.

Regards

Siva.M

---

looksmee (BOB member since 2006-02-08)

[system]

Have a look at these first before just jumping in:

Using Designer to Implement Row-Level Security

Author: Steve Krande Further discussion on this downloadable should take place in this topic. Author’s Notes: UsingDesignerToImplementRowLevelSecurity.zip (425.0 KB) BOB Downloads (BOB member since 2003-05-05)

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 …

---

MikeD (BOB member since 2002-06-18)