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.

[Former Member]

Hi Shahid,

After you activated your view you should execute SQL in your database (rightclick on your cloud system on Systems tab in Eclipse and choose Open SQl Console):

Executre this script:

CALL "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS";

Then go to Systems > Catalog > _SYS_BIC > Column Views and try data preview on an entry there.

This sequence applies to the SAP HANA Trial Cloud system. Hope this helps.

Regards,

Yury

[Former Member]

Hi  Yury Medvedev,

we don't have data preview option for viewing data from analytical view as suggested to view from _SYS_BIC. can you guide me how to get data preview option.

As suggested above, Executed the steps. But having issue with privileges. I hope we need to add following privileges CATALOGREAD and DATA ADMIN to current user..

[santhu_gowdaz]

hi shahid,

          please refer this link.

http://scn.sap.com/thread/3202647

[Former Member]

Hi,

Please post this issue under SAP HANA Cloud Platform space. The platform experts should be able to help with that.

Regards,

Ifat.

[Former Member]

I also faced the same issue, it has solved with your tip