Authorization checked for infoObjects even though not relevant to report
I am facing a problem in BI 7.0 authorization checks.
For a given report the BI team has placed a restriction in the query only for infoObject 0Comp_code (company code) and 0SOLD_TO (sold to party). Accordingly i have created authorization in RSECADMIN and assigned to role--> user.
But when the user runs the report, he gets as authorization error and during analysis in RSECADMIN i see that "list of Authorization relevant charecteristics(infoObjects) for info provider xxxx" contain other infoObjects as well.
Is it a case where infoObjects can be made authorization relevant for the whole info provider eg-ZSD_M42" (where this is a multi provider)apart from being checked for specific reports eg- ZSD_M42_Q0001?
How do i get around this problem?
Yes, you got it right. And depending on your requirements you can restrict the auth relevant characteristics.
So, when a query is fired at a infoprovider, a check is performed for all the auth relevant characteristics of that infoprovider with what user has (via AA Objects). If user lacks any of it, a authorization error is generated.
So you need to make sure that all auth relevant characteristics of infoproviders on which query is fired are included in AA object for query to run sucessfully