59684

SAP HANA Authorisation Error: SAP DBTech JDBC: [258]: insufficient privilege: search table error: [2

Question:

At the moment I try to understand SAP HANAs authorisation concept.

I assigned the analytic user the following rights:

<ul><li>select on _SYS_BI, _SYS_BIC</li> <li>execute on REPOSITORY_REST</li> <li>root package: REPO_READ</li> </ul>

If I create an analytic privilege on an information view and assign this privilege to the user then the user is able to query the information view.

On the other hand the modeller does not need this analytic privilege to query the information view. So there must be another way to allow the user to query the data - right? And I try to understand how.

Without the analytic privilege the user gets the following error:

<strong>Error: SAP DBTech JDBC: [258]: insufficient privilege: search table error: [2950] user is not authorised</strong>

<strong>So which privilege is missing?</strong> What is search table error?

Answer1:

This question really is more about concepts and not so much about how to do something specific. I recommend to use the <a href="https://scn.sap.com/community/hana-in-memory" rel="nofollow">SAP Community Network (SCN)</a> community for this kind of question.

Generally speaking, modeller roles tend to have a "see all" privilege, which allows them to see all data. The "search table error" is a general error message used by SAP HANA and can indicate basically any problem with data access. The specific information are provided in the details part of the error message. In this case that's : <strong>[2950] user is not authorised</strong>

Recommend

  • Configuring UTL_MAIL Package Prerequisites
  • For each row check if value in one column exists in two other columns
  • Why segmentation cannot be completely disable?
  • Running scripts from Perl CGI programs with root permissions
  • Mocha throws unexpected token error for ES6 object spread operator
  • Criterion causing memory consumption to explode, no CAFs in sight
  • where do I find the xml.dom python package for the python-2.6.0-8.9.28 and I have a suse/x86_64 vers
  • Spring boot 2.0.0.M4 required a bean named 'entityManagerFactory' that could not be found
  • Read text file that is not in the main package in a runnable jar
  • Roxygen error “Skipping invalid path”
  • Assign variable to the value in HTML
  • d3 v4 drag and drop with TypeScript
  • Word Open XML Mail Merge
  • Meteor: Do Something On Email Verification Confirmation
  • why do I get the error when installing the gem 'pg'? [duplicate]
  • SignalR .NET Client Invoke throws an exception
  • Using variable in a value field in jMeter
  • Using $this when not in object context
  • Array.prototype.includes - not transformed with babel
  • Volley JsonObjectRequest send headers in GET Request
  • Accessing IRQ description array within a module and displaying action names
  • DirectX11 ClearRenderTargetViewback with transparent buffer?
  • Can a Chrome extension content script make an jQuery AJAX request for an html file that is itself a
  • Redux, normalised entities and lodash merge
  • Why is the timeout on a windows udp receive socket always 500ms longer than set by SO_RCVTIMEO?
  • Build own AppleScript numerical error handling
  • Websockets service method fails during R startup
  • Web-crawler for facebook in python
  • Google cloud sdk not working when python points python3
  • Is there a mandatory requirement to switch app.yaml?
  • Cannot Parse HTML Data Using Android / JSOUP
  • Unit Testing MVC Web Application in Visual Studio and Problem with QTAgent
  • Hits per day in Google Big Query
  • How get height of the a view with gone visibility and height defined as wrap_content in xml?
  • how does django model after text[] in postgresql [duplicate]
  • FormattedException instead of throw new Exception(string.Format(…)) in .NET
  • Getting Messege Twice Using IMvxMessenger
  • Linking SubReports Without LinkChild/LinkMaster
  • XCode 8, some methods disappeared ? ex: layoutAttributesClass() -> AnyClass
  • How to load view controller without button in storyboard?