01-25-2018 2:17 PM
Hi!
Everything set up according to the main article - Authorizations for Generating SAP HANA Views
1) User <X> created via SU01 with correct roles:
2) Composite Provider (ZMM1VP01) created over Calculated View (CV_MM1D04) with Hana External View selected
3) AP generated as expected
4) After querying Hana External View with this user got error
5) Message in trace file
[49849]{443440}[190/-1] 2018-01-25 16:44:51.596522 i AuthorizationceAuthorizationCheckImpl.cpp(00470) : AuthorizationCheckHandler::isAuthorizedToSelect (AP check on CalcScenarioDS): User <X> is not authorized on _SYS_BIC:znn.mm1/CV_MM1D04 (t -1) (main view: SAPMBD:0BW:BIA:ZMM1VP04 (t -1)due to XMLAP check
[49849]{443440}[190/-1] 2018-01-25 16:44:51.596645 e CalcEngine ceModelBuilder.cpp(01342) : CalcEngine Exception: exception 306003: Authorization failed in Calculation Engine. User is not authorized to 'SELECT'
CONSLUSION:
User has not access to underlying CV. Expected, that additional AP will be generated.
Q: How CP or user or smth should be configured to delegate access to underlying objects?