SAP HANA授权错误:SAP DBTech JDBC:[258]:权限不足:搜索表错误:[2950]用户未被授权 [英] SAP HANA Authorisation Error: SAP DBTech JDBC: [258]: insufficient privilege: search table error: [2950] user is not authorized

问题描述

此刻，我试图理解SAP HANA的授权概念.

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

我为分析用户分配了以下权限:

I assigned the analytic user the following rights:

• 在_SYS_BI，_SYS_BIC上选择
• 在REPOSITORY_REST上执行
• 根软件包:REPO_READ

如果我在信息视图上创建了分析特权并将此特权分配给用户，则用户可以查询信息视图.

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:

错误:SAP DBTech JDBC:[258]:特权不足:搜索表错误:[2950]用户未被授权

那么缺少哪个特权?什么是搜索表错误?

推荐答案

这个问题实际上更多地是关于概念的，而不是关于如何做特定的事情的.我建议使用 SAP社区网络(SCN)社区来解决此类问题

This question really is more about concepts and not so much about how to do something specific. I recommend to use the SAP Community Network (SCN) community for this kind of question.

通常来说，建模者角色通常具有查看全部"特权，这使他们可以查看所有数据. 搜索表错误"是SAP HANA使用的一般错误消息，基本上可以指示数据访问方面的任何问题.在错误消息的详细信息部分中提供了特定的信息.在这种情况下，该用户是: [2950]用户未被授权

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 : [2950] user is not authorised

这篇关于SAP HANA授权错误:SAP DBTech JDBC:[258]:权限不足:搜索表错误:[2950]用户未被授权的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！