HAHA激活视图报 Insufficient privileges - not authorized 的权限问题

最新推荐文章于 2024-06-12 13:58:37 发布

原创最新推荐文章于 2024-06-12 13:58:37 发布 · 2.4k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#HANA #SAP

SAP HANA 专栏收录该内容

3 篇文章

订阅专栏

本文介绍在SAP HANA中使用Eclipse创建AttributeView时遇到的权限不足错误，并提供两种解决方案：一是通过_SYS_REPO用户授予SYSTEM模式下的SELECT权限；二是执行特定的SQL命令。最终成功解决部署AttributeView的问题。

场景:导入SAP HANA提供的虚拟机,启动完成后,通过eclipse使用SYSTEM用户连接HANA.

1, Catalog -> SYSTEM -> 新建一个test表.

2, Contnet -> 新建一个package -> 新建Attribute View

3, add TEST表到 TEST 视图,并Activate视图.报如下错误.

描述如下:

Short Text
Insufficient privileges - not authorized

Cause
User is not authorized to deploy attribute view

Recommendations
Grant SELECT privileges on schemas of the used data foundation tables to user "_SYS_REPO"

Error Message
   Repository: Encountered an error in repository runtime extension; Deploy Attribute View: SQL: insufficient privilege: Not authorized
   Create view DDL statement: CREATE COLUMN VIEW "_SYS_BIC"."tangzhen/TEST" TYPE JOIN WITH PARAMETERS ( joinIndex = "SYSTEM"."TEST", joinIndexType = 0, viewAttribute = ('ID', "SYSTEM"."TEST", "ID", '', 'default', 'attribute', '', 'tangzhen/TEST$ID'), viewAttribute = ('NAME', "SYSTEM"."TEST", "NAME", '', 'default', 'attribute', '', 'tangzhen/TEST$NAME'), view = ('V_TEST', "SYSTEM"."TEST"), defaultView = 'V_TEST', 'REGISTERVIEWFORAPCHECK' = '1' ) NO STRUCTURED PRIVILEGE CHECK

通过查询SAP社区,有两种方案:

1. Please open the "_SYS_REPO" user account, go to "SQL Privileges" tab, add "SYSTEM" schema and check on "SELECT" and click on "Yes" radio button under Grantable to others.

2. Run the SQL command:

GRANT SELECT ON SCHEMA SYSTEM TO _SYS_REPO WITH GRANT OPTION;

可能eclipse的版本不同,第一种方式操作时,我没有找到SQL Privileges选项.所以我使用的是第二种方式,直接执行了sql语句:GRANT SELECT ON SCHEMA SYSTEM TO _SYS_REPO WITH GRANT OPTION;

问题解决..

参考:https://archive.sap.com/discussions/thread/3408581