Symptom
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: [258]: 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.
because he is missing any structured privileges applicable to that object"> Read more...
Environment
- SAP HANA Platform Edition 1.0
- SAP HANA Platform Edition 2.0
Product
Keywords
SAP DBTech JDBC, 258, insufficient privilege, is not authorized to access, missing any structured privileges applicable to that object, _SYS_BI_CP_ALL, SQL Analytic Privilege, Classical Analytic Privilege , KBA , HAN-DB-SEC , SAP HANA Security & User Management , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.