Skip to Content
0
Former Member
Oct 26, 2007 at 09:13 PM

Authorization BI 2004s : restricting access to infoproviders in multi prov

16 Views

Hi

I have a multiprovider that contains 5 DSOs.

Is there a way I can setup security such that user 1 has access to all 5 DSOs, however user 2 has access to only 2 DSOs.

Thus, when user 1 runs a report off the multiprovider, they will have access to data from all the 5 DSOs.

However, when user 2 runs the same report, they will have access to data from only 2 DSOs. So, the columns that are relevant to those 2 DSOs contain data, however, the columns relevant to the other 3 DSOs are blanked out?

Thank you very much..

I will make sure to assign points.