Row-level security in BO XI Rel.2

system · October 22, 2006, 12:37pm

Hello,

I have a problem with the implementation of row-level security. The security is like
user a: company = 1
user b: company = 2

I create the restrictions and mapped it to the BO User. If I check the restrictions in the designer, it is ok.

Now, I make a report. It works fine, if the company-table is in the sql-query. Then I see the correct values. But if I only select the customer without the company in the select-stmt, it shows me all data and there is no filter like “company = 1” in the where clause.

Can everybody help me???

Thanks
Andreas

sban (BOB member since 2003-12-11)

system · October 22, 2006, 3:30pm

This means you’ve restricted the company table. What you need to do is add the table to the object definitions that need to be restriced. This is done using the tables button.

You should read this for suggestions on ways to do what you want. It was written for V5/V6, but it still applies. Only the method for entering the conditions has changed.

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