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: : insufficient privilege: search table error:  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> user is not authorised</strong>