[258]: insufficient privilege: [2950] user is not authorized - Calculation View

[Former Member]

Hi

A user is getting this error while accessing a calculation view: "Error: SAP DBTech JDBC: [258]: insufficient privilege: [2950] user is not authorized".

I tried the troubleshooting steps in SAP note 2433916, the output in the IndexServer trace file is:

[52432]{333895}[58/-1] 2017-07-20 16:37:10.199745 i TraceContext TraceContext.cpp(00952) : UserName=TESTUSER1, ApplicationUserName=ht1adm, ApplicationName=HDBStudio, ApplicationSource=csns.modeler.datapreview.providers.ResultSetDelegationDataProvider.<init>(ResultSetDelegationDataProvider.java:130);csns.modeler.actions.DataPreviewDelegationAction.getDataProvider(DataPreviewDelegationAction.java:339);csns.modeler.actions.DataPreviewDelegationAction.run(DataPreviewDelegationAction.java:279);csns.modeler.actions.DataPreviewDelegationAction.run(DataPreviewDelegationAction.java:133);csns.modeler.command.handlers.DataPreviewHandler.execute(DataPreviewHandler.java:70);org.eclipse.core.commands, StatementHash=0434df96fdc58c9cf212c106daa66392

[52432]{333895}[58/-1] 2017-07-20 16:37:10.199715 i Authorization XmlAnalyticalPrivilegeFacade.cpp(01330) : Authorization error: User TESTUSER1 is missing analytic privileges in order to access _SYS_BIC:TFR/TESTDATA_MAX There aren't any AP's defined for that view.

[52432]{333895}[58/-1] 2017-07-20 16:37:10.199766 i Authorization ceAuthorizationCheckImpl.cpp(00419) : AuthorizationCheckHandler::isAuthorizedToSelect (AP check): (Original) User TESTUSER1 is not authorized on _SYS_BIC:TFR/TESTDATA_MAX (t -1) due to XmlAP check

[52432]{333895}[58/-1] 2017-07-20 16:37:10.199905 i Authorization XmlAnalyticalPrivilegeFacade.cpp(01330) : Authorization error: User TESTUSER1 is missing analytic privileges in order to access _SYS_BIC:TFR/TESTDATA_MAX There aren't any AP's defined for that view.

[52432]{333895}[58/-1] 2017-07-20 16:37:10.199999 i Authorization XmlAnalyticalPrivilegeFacade.cpp(01330) : Authorization error: User TESTUSER1 is missing analytic privileges in order to access _SYS_BIC:DiBo.Financials/VERSION There aren't any AP's defined for that view.
[52432]{333895}[58/-1] 2017-07-20 16:37:10.200056 i Authorization XmlAnalyticalPrivilegeFacade.cpp(01330) : Authorization error: User TESTUSER1 is missing analytic privileges in order to access _SYS_BIC:DiBo.Financials/PERIOD_NAME There aren't any AP's defined for that view.
[52432]{333895}[58/-1] 2017-07-20 16:37:10.200123 i Authorization XmlAnalyticalPrivilegeFacade.cpp(01330) : Authorization error: User TESTUSER1 is missing analytic privileges in order to access _SYS_BIC:DiBo.Financials/COST_OBJECT There aren't any AP's defined for that view.
[52432]{333895}[58/-1] 2017-07-20 16:37:10.200168 i Authorization XmlAnalyticalPrivilegeFacade.cpp(01330) : Authorization error: User TESTUSER1 is missing analytic privileges in order to access _SYS_BIC:DiBo.Financials/LINE_ITEM There aren't any AP's defined for that view.

[52432]{333895}[58/-1] 2017-07-20 16:37:10.200412 e SqlOpt_ceqo Ce2qoUtils.cc(00903) : Ptime Exception: insufficient privilege: [2950] user is not authorized : occurred while unfolding _SYS_BIC:TFR/TESTDATA_MAX

Not sure what Auth is missing, please assist?

[Former Member · Accepted solution]

Hi Peter

It was a bug in the database on version 12.04, we fixed it by re-activating all the affected views then upgrading to 12.11.

[pmuschick]

Hello Willem,

were you able to fix your issue? I am facing a similar problem. Even the full Analytical privilegues profile does not work. Is there something wrong in the view definition?

UPDATE: I was able to solve this by accident for me now. I reset the the "Apply Privilege" to <blank> and then back to original value <Classic Analytical Privileges>. Suddently it worked without changing anything else. Hopefully it works for you too - however this is not a fix and seems like a bug in the database which should be reported.