Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SAP Hana - Data Preview of Attribute View fails

Hello,

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: [258]: insufficient privilege: Not authorized

(I'm doing this in SAP Hana Modeler in Eclipse)

How can I fix this error?

Tags:
Former Member
Former Member replied

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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question