Skip to Content
Mar 29, 2013 at 02:52 PM

How to grant access to an analytic view?



I am just starting with HANA and I am really confused about authorizations. I have created a schema, a table, a package, an analytical view and a user which should be able to see the analytical view. Ich have granted the sql select and execute authorizations to my new schema and the schema _SYS_BIC and the package privilege to my new package, no analytical privileges yet.

When I try to execute the data preview with my new user, I get this error:

Could not execute 'SELECT * FROM "_SYS_BIC"."simon/HISTORY/cluster/hier/cluster" SAP DBTech JDBC:[258] (at 25): insufficient privilege: Not authorized: line 1 col 26 (at pos 25).

The preview works for user _SYS_REPO. Which privilege might be missing for my new user? Are analytical privilege mandantory when working with an analytical view?

Thanks for any hint.