Symptom
The error below is occurring in Analysis for Office when trying to connect to HANA system:
"Caught exception : exception 42111: SQL Error : insufficient privilege: Not authorized at ptime/query/checker/query_check.cc:3389 (42014)"
The HANA revision is lower than 102.06.
Environment
SAP BusinessObjects Analysis, edition for Microsoft Office
Resolution
Refer to SAP note 2339729 for the solution, which is an upgrade in HANA side, or use the workaround mentioned in the note.
Keywords
privilege, authorization, role, user, logon, login, access, unable, error, exception, authorized , KBA , BI-RA-AO-CON , Please use component BI-RA-AO-XLA , BI-RA-AO-XLA , Excel Addin , Problem