Skip to Content
0
R S
May 24, 2016 at 07:03 AM

Can not execute Procedure GRANT_ACTIVATED_ANALYTICAL_PRIVILEGE

445 Views

Hi Experts,

We have created SQL privilege in HANA and now want to assign it to repository role. So I am using below procedure

Call GRANT_ACTIVATED_ANALYTICAL_PRIVILEGE ('"ZANPSQL_HR_PERSONALDATA"','Repsoitory Role with Path');

error:

Could not execute 'CALL _SYS_REPO.GRANT_ACTIVATED_ANALYTICAL_PRIVILEGE ...' in 98 ms 576 µs .

[129]: transaction rolled back by an internal error: insufficient privilege: Not authorized

Both SQL privilege and Repository created by one USER and same user we are using to execute the procedure.

We have assigned the GRANT_ACTIVATED_ANALYTICAL_PRIVILEGE(_sys_repo.) under object privilege node.

Please suggest why we are getting the error.

* Is it possible to assign SQL privilege to repository role using above procedure?

Regards

Rajender Singh