SAP Knowledge Base Article - Preview

3263124 - Get insufficient Privilege when using non-ABAP DBMS user to query the BW generated CVs


When you using non-ABAP DBMS HANA user to query the BW generated external calculation view or you query on a Hana calculation views which are based on BW External HANA views.

For example, you use Smart Data Access (SDA) to create Remote Source with specified database user. 

You get the insufficient privilege error which similar with the symptom of note 2390443 - BW External SAP HANA Views and Analytic Privileges.

You want to know if there is a way to assign the necessary analytical privileges automatically.



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


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 , 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.