HAHA**视图报 Insufficient privileges - not authorized 的权限问题
场景:导入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;
问题解决..