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 BW/4HANA
• 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