Hi,
We are using BW on HANA system. There are some cubes in BW, for which HANA views are generated. So far we had set up data security using BW
analysis authorizations and HANA authorizations are generated using RS2HANA_CHECK. But now we have a need to set up security directly in
HANA.
To achieve this, I created analytic privilege in HANA for the information model. For example, analytic view ZC1XXX11 is generated for BW cube of same name. I created analytic privilege ZTEST_AP_XXX11 and assigned to a user. The user is also assigned necessary privileges, like SELECT on _SYS_BI, _SYS_BIC, EXECUTE on Repository_Rest procedure and the package privilege.

But still when the user tries to view data from analytic view ZC1XXX11, he gets error message “Insufficient Privilege”. When I check the trace,
I get below message:
“User TEST_USER6 is not authorized to access _SYS_BIC.ZPK_XX/ZC1XXX11 because he is missing any structured privileges applicable to that
object”.
Could anyone please suggest what could be the issue.
When we analysis authorization to the user in BW and generate HANA authorizations for it, everything works fine. But we need to create the privileges manually in HANA, in which case its not working.
Thanks
Nitesh Gupta