SAP Knowledge Base Article - Preview

3263124 - Get insufficient Privilege when using HANA DB user to query HANA calculation view

Symptom

When using HANA database to query any type of calculation views and get the error message: 

insufficient privilege: Detailed info for this error or can be found with guid <XXXXXXX>

or 

Error executing the query: „Error: SAP DBTech JDBC: [258]: insufficient privilege:[2950]user is not authorized

You found this user missing HANA analytical privilege.

You want to know if there is a way to check the missing analytical privileges or deactivate the analytical privilege check.


Read more...

Environment

  • SAP HANA, platform edition 1.0
  • SAP HANA, platform edition 2.0
  • SAP NetWeaver 7.4
  • SAP NetWeaver 7.5
  • SAP BW/4HANA
  • SAP HANA Studio

Product

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

Keywords

Invalid SQL AP definition, RS2HANA_AUTH_RUN, SQL Analytical privilege, insufficient privilege, [2950]user is not authorized  , KBA , HAN-DB-SEC , SAP HANA Security & User Management , BW-WHM-MTD-HMOD-AUT , BW2HANA authorization generation , How To

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.