SAP Knowledge Base Article - Preview

2540498 - User "USER_NAME" is not authorized to access < VIEW> because he is missing any structured privileges applicable to that object

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

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

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.