Different Sceurity Profile depending on capsule
Hi everyone,
in our board system we use different capsules and usually every user (apart from the admins) only has access to one capsule. We now have the special case that one user is supposed to have access to two capsules. The problem is that in one of the capsules he only is allowed to see data for one company and in the other capsule he is allowed to see data for every single company. (We have an entity called company with all of the companies belonging to our group as members)
Is there a way to achieve this in board without giving the user a second board access?
Thank you
Answers
-
Hi
there are several possible solutions.
On one customer we using a replicated DB for problems like this. There is a planning DB, were every user only can see his company (and so he only can plan his figures). Then we have a 2nd DB (Reporting), which is a nightly copy of the Planning DB. Here the users are allowed to see all companies (but on different cubes).
Hope this might also fit for your problem
regards
Björn
1 -
Another idea is to replicate cubes and use a differnt entity for the company.
Restriction to be set in only one entity.
0 -
Hello,
thank you. Both solutions could work, although I think in our case the cube replication would be the most feasible.
On the other hand replicating all of our cubes just for one user is probably a bit overkill. So I think we will restrict the user to the one company in both capsules for now and then see if they can live with it.
Best,
Friedrich
1
