I was trying to give row level security to an object but couldn’t do it properly. I was doing this using the manage access restriction. Is it the right process? Also wanted to know how to do object level security and how does it work?
BO_User2000 (BOB member since 2008-11-18)
Look here for a presentation by Steve Krandel on the topic of row-level security. You will need an additional security table mapping your BO user IDs to the grnated dimension values (BOUSER1 = UK, BOUSER2 = Germany, etc.), see also here and here
Keep in mind, you might be better off using [i]Virtual Private Databases /i such as in Oracle, which is totally transparent to BusinessObjects.
Also, realize that object-level security deals with columns, whereas row-level security… well deals with rows.
Andreas 
(BOB member since 2002-06-20)
Arjun, there is nothing in your blog.
Andreas, Can we not do in Designer without using an additional table ? Steve’s presentation is based on earlier version.
Is there any documention available for row level security in Designer using XIr2 ?
Developer_Designer (BOB member since 2009-08-09)