Skip to Content
author's profile photo Former Member
Former Member

SAP DBTech JDBC: [258]: insufficient privilege ... again!

I have found plenty of threads on the subject of "SAP DBTech JDBC: [258]: insufficient privilege", but nothing that seems to be helpful for my situation

The following statement on compposite provider 'COM_PROV_XYZ':


select * from "_SYS_BIC"."system-local.bw.bw2hana/COM_PROV_XYZ";

fails with the message:


Could not execute 'select * from "_SYS_BIC"."system-local.bw.bw2hana/COM_PROV_XYZ"'

SAP DBTech JDBC: [258]: insufficient privilege

The following select on calc view 'YYY' works though:

select * from "_SYS_BIC"."ProjectX/YYY"

Which agrees with the fact that the user has been granted roles with the followin auths:

(also the case for _SYS_BIC and _SYS_REPO)

Also:

Any ideas out there?

Unbenannt.JPG (35.7 kB)
Unbenannt.JPG (40.3 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Feb 24, 2016 at 05:06 PM

    Hello,

    Have you tried running a trace whilst reproducing the error?

    Please see the Troubleshooting Authorizations Guide for information on how to activate the trace.

    Please paste trace information here so we can have a look.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 25, 2016 at 12:40 PM

    Hi,

    I order to view the data, Analytic privileges on the view are required for the user apart from the _SYS_BIC and _SYS_BI privileges.

    Also, the trace above mentions:

    User XXX is not authorized to access _SYS_BIC.system-local.bw.bw2hana/A9CO_ER_ES07 because he is missing any structured privileges applicable to that object


    Here, structured privileges refer to the analytic privilege to the user.

    Can you check if the user has the respective Analytic privilege.


    For analytic privilege you can refer the help.sap.com at

    Analytic Privileges - SAP HANA Developer Guide for SAP HANA Studio - SAP Library


    Thank you.

    Anjali.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 09, 2016 at 07:38 AM

    Hello,

    we had the same problem or error message while executing the model (calculation view based on generated SAP HANA view in BW) in a BW transformation. Every time we executed the DTP and the transformation (SAP HANA expert scripted based transformation) we received the same error message regarding missing structured authorization of the generated SAP HANA view.

    Activating the transformation again solved the problem. So simple, quiet so complicated.

    I guess it has something to do with a BW note with switched from "each view one analytical privilege in one role" to "one role for all analytical privileges". The change affected the transformation obviously only when reactivating it. But don't ask me which SAP Note causes this authorization switch.

    Good luck!

    Marcel

    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.