how to restrict BOUSER

[system]

helllo everyone,

i have issue

there are n number of BOUSER with their respective unit_id

whenever the BOUSER login with his name he should get data corresponding to his unit_id only,

I just tried by creating a table with user_name and unit_id
and tried to use @variable, when BOUSER enter his/her username
it should connect to unit_id and should acces the rights given to the BOUSER.

thankyou in anticipation

john.

---

johnedward (BOB member since 2008-04-04)

[system]

This is called ROW LEVEL SECURITY in 6.5 and XI… … and there is another option in BO XI R2 with which you can manage this using PROFILE’s.

Make sure you add the security table in the universe and join with the other dimensions tables(s) on which you want to apply security.

In 6.5 and lower versions, add a condition on the universe in Supervisor.
In XI R2, you can add similar condition in the Designer itself.

If you need more information, Please search "ROW LEVEL SECURITY* in the forum.

---

BO_Chief (BOB member since 2004-06-06)

[system]

You have a duplicate post with discussion going on here

I have 20,000 users, we have to generate reports.

hello everybody, i have a issue here that is: I am using BOXI R2 on .net framework2.0(IIS Web Server) Issue: I have 20,000 users, we have to generate reports for 20,000 users. we have to keep security so that every user can see his/her own data. Can anyone please help me how to solve the issue in step wise. thankyou in anticipation john. johnedward (BOB member since 2008-04-04)

Please do not cross-post, it leads to fragmentation

.

---

haider (BOB member since 2005-07-18)

[system]

Please do not cross-post. It leads to fragmented discussions and is against our forum rules.

This topic is closed. Continue discussion in the other topic that is hyperlinked above.

---

Anita Craig (BOB member since 2002-06-17)