The connection to our HANA DB via ODBC works fine.
When selecting tables and try to load the data we get errors like this one:
SQL##f - SqlState: S1000, ErrorCode: 258, ErrorMsg: [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] General error;258 insufficient privilege: Not authorized SQL SELECT CALMONTH, CALQUARTER, CALWEEK FROM "_SYS_BI"."M_TIME_DIMENSION"
The restricted user on HANA DB side has the following authorizations:
System Privileges: CATALOG READ
Object Privileges: _SYS_BIC
Analytic Privileges: SYS_BI_CP_ALL
I think it has nothing to do with authorizations.
On the other side we can load data stored by Lumira application on HANA DB:
SQL SELECT *
Any ideas how to fix the error issue?
Hi Sarvesh Example: //This generated code doesn't work! SQL SELECT ADDRESSTYPE, Brutto, DELIVERYDATE FROM "_SYS_BIC"."sap.hana.bnd_fatho/COPY_2_OF_ZPO_HEADER"; //This manipulated/modified code works! SQL SELECT ADDRESSTYPE, TO_DOUBLE("Brutto") as Brutto, DELIVERYDATE FROM "_SYS_BIC"."sap.hana.bnd_fatho/COPY_2_OF_ZPO_HEADER";
We are starting the impementation of a project, however, we have had connection problems.
I read your post and use the role and privileges you mention, however, the connection test is successful but the schemas and tables are not displayed.
I would like to know if you need other permissions or roles to be able to connect and extract data from SAP HANA or is there any info available online that contains the minimun requeriments and permissions you need to perform this operation?