on 01-22-2014 6:15 AM
当我在hana cloud上按照“HANA Academy”视频练习“Creating Decision Tables with update values”的时候碰到个问题,我无法激活,可能是权限的问题,有哪位高手帮忙看看什么原因,下面是错误信息和截图。
Message :
Repository: Internal error during statement execution, please see the database error traces for additional details; error in generated procedure - insufficient privilege: Not authorized at ptime/query/checker/query_check.cc:2225line: 0 column: 0
You can run GRANT SELECT, UPDATE ON SCHEMA YOUR_SCHEMA TO _SYS_REPO WITH GRANT OPTION
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
一般情况下, 出现这个错误的原因是没有赋给_SYS_REPO user 对此decision table 所用到的底层table足够的操作权限。解决这个问题可以直接在 SQL console里面执行:
grant select on table <table_name> to _sys_repo;
grant execute on table <table_name> to _sys_repo;
grant update on table <table_name> to _sys_repo;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
你可以先检查一下用户(或者该用户所属角色)上定义的权限,把所有SQL Privileges全勾上。
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
92 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.