HANA – Ptime Exception: insufficient privilege: [2950] user is not authorized : occurred while unfolding

In a few words, I will try to outline the situation in which I get the error mentioned in the topic of the article.

  • Firstly, technical user was created to access HANA Calculation Views (CV).
  • Secondly, CVs are built in specific package and they are using data from other packages.
  • Thirdly, user can access one CV, which built as a projection from database table and is joined with two CVs generated by BW (master data).

Error is occuring when user tries to access CV which is built on top others CV from other package. Following error message is displayed:

Could not execute 'SELECT * FROM "_SYS_BIC"."Calculation_View_object"'
SAP DBTech JDBC: [258]: insufficient privilege: [2950] user is not authorized :
[8515] {336127}[183/-1] 2021-05-14 12:07:24.137470 i TraceContext TraceContext.cpp(01268) : UserName=HANA_USER, ApplicationUserName=APP_USER, ApplicationName=HDBStudio, ApplicationSource=csns.sql.editor.SQLExecuteFormEditor$2$1.run(SQLExecuteFormEditor.java:920);, Client=800, StatementHash=cb2f61rrt4d9c487e8a972b46afe6583, StatementExecutionID=844438548931282
[8515]{336127}
[183/-1] 2021-05-14 12:07:24.137462 e SqlOpt_ceqo Ce2qoUtils.cc(01201) : Ptime Exception: insufficient privilege: [2950] user is not authorized : occurred while unfolding _SYS_BIC:Calculation_View_object

Solution

You should check the following KBA:
2433916 – Ptime Exception: insufficient privilege: [2950] user is not authorized : occurred while unfolding

If you want to grant users with full data access to all information views in your SAP HANA system, then assign the analytic privilege _SYS_BI_CP_ALL to the users. 
If you want to grant only restricted data access to information views, then create an analytic privilege with filters by including these information views as secured models, and assign this analytic privilege to the user role.

Please refer to the guide:
https://help.sap.com/viewer/b3ee5778bc2e4a089d3299b82ec762a7/2.0.05/en-US/db08ea0cbb571014a386f851122958b2.html?q=analytic%20privilege

Copyright © 2021. SAPBasisWorld.com Privacy Policy