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;

问题解决..

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