Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos


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.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos


we have a special characteristic authorisation object known as OTCAIPROV through which we can authorise the certain number of infoproviders to some person by giving this authorisation to his role.

Refer to this link

Hope this helps