SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

[Former Member]

I am using SAP HANA Cloud Trial; I created Analytic View based on two table dimension table and fact table, I can display content from both tables, but I can not display data preview from my Analytic View, getting authorization message;SAP DBTech JDBC: [258]: insufficient privilege: Not authorized.

please the steps I took.

Shahid

[gowrisankar_m2]

Hello,

This is due to the trial system limitation, dont work for analytic view and it can be achieved by doing a workaround.

1. Please create your database artifacts under neo_XXXXXX schema. Please create now analytic view using tables from neo_xxx schema.

2. Now just create a calculated column in analytic view with type attribute.

3. Now activate the view and call CALL "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS";

4.Now to _sys_bic schema -->column views-->do the datapreview of your view, it should work

BR ,Gowrisankar