SAP Hana - Data Preview of Attribute View fails
I have an Attribute View created in my package, and it uses tables from my schema. I was able to Validate and Activate the Attribute view after using the following SQL:
GRANT SELECT ON SCHEMA "<SCHEMA_NAME>" to _SYS_REPO WITH GRANT OPTION;
But when I do a Data Preview of this Attribute View, and click on Raw Data, I get the following error:
Error: SAP DBTech JDBC: : insufficient privilege: Not authorized
(I'm doing this in SAP Hana Modeler in Eclipse)
How can I fix this error?
I found a solution to my problem and I am posting it here.
In order to do a Data Preview of Attribute views, you need to run the SQL (Call "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS") AFTER deleting all tables in your Dev schema. I was running it with tables still in my DEV schema, and hence it was throwing this error. The second part is that I need to recreate these tables in my NEO schema, and not the DEV schema.
After deleting my tables, I ran the SQL, and then recreated my tables in the NEO schema. Then I recreated my attribute view, and activated it. The _SYS_BIC schema started to show. And I could do a Data Preview of my Attribute Views.
Hope this helps anyone who faces the same issue.