Skip to Content
author's profile photo Former Member
Former Member

Report Security


I have requirement to show the report data only users for specific regions. For example, i have 2 regions and we have users in each region. If user from region 1 seeing the report then he should see only his region related information.

I have done this using row level security in universe level using BO user. But the issue is, we used to add new users frequently. If this is the case then i need to hard code the user name (BO user) every time in universe.

This is not possible. Is there any possibility to apply the security to groups without hard code users because if new user means we can add it in to the groups.

We are not storing the user names in separate table, user names can see only in groups.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 16, 2015 at 06:10 PM


    You can create row level security using groups instead of users.

    We can use "Manage Access Restriction" Option in Universe Designer.In Designer,Go to Tools-->Manage Security-->Manage Access Restrictions--> Specify the Name to Restriction-->In Row tab(Select table and give the condition)-->Assign this restriction to the user/group.(This restricts a user to access values corresponding to the specified condition

    Check the below link for reference.

    Row Level Security / Restriction in BO Universe Designer | DWBI castle

    If you are using IDT, create a Business security profile, create a filter for region 1 and assign the user group. Repeat the same for other regions.

    Business Objects 4x Information Design Tool - Business Security Profiles - YouTube

    -Sri Harsha

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.