BusinessObjects Board

row level security

building semantic layer
#1

Hi,

We are trying to implement row level security in Designer.
I’ve read the Designer FAQ, in which Dave Rathbun explained


You can impose the security restrictions in Designer, by using self-joins and a maintained lookup table. You might end up with self-joins along the lines of: 
Code: 
DataTable.Region in ( Select Region From SecurityLookup Where User = @BOUSER)

Could some one explin me more in detail.

We’ve level code in one table. And there are 5 levels. Only users belonging to their group can see their data. Please explain me how to implement for this.

We are using BO 6.5.1.

Thanks,

k_Raj (BOB member since 2004-02-24)

#2

See this topic:

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