Skip to Content

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

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?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Sep 08, 2017 at 11:59 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 07, 2017 at 03:17 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.