When trying to SELECT or view some data in a view that is based on an SQL Analytic Privilege, you see the following error appearing:
SAP DBTech JDBC: : insufficient privilege.
Tracing the error further you find the following error in the indexserver.trc file:
"User <USER_NAME> is not authorized to access "VIEW_NAME" because he is missing any structured privileges applicable to that object"
The user in question also has been assigned the "_SYS_BI_CP_ALL" system privilege but it still fails.
Read because he is missing any structured privileges applicable to that object">more...
SAP HANA 1.0
SAP HANA 2.0
KBA , HAN-DB-SEC , SAP HANA Security & User Management , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.