Insufficient privilege on SAP HANA causing installation issues - General error;258 insufficient privilege

In case you decide to use a dedicated database user other than the SYSTEM user in SAP HANA environment you might phase similar errors when try to install WMS, or start the Add-on in SAP Business One:

Failed to load plugin(s): Produmex.Sbo.Logex.AddOnPlug -> 1). [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;258 insufficient privilege: Detailed info for this error can be found with the guid '4913642A39296046BE1A445BB8DC7DF9'

[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;258 insufficient privilege: Detailed info for this error can be found with guid '8DF930A66023384B923AC6828475EA68' Query: SELECT "COLUMN_NAME" FROM "SYS"."COLUMNS" WHERE "SCHEMA_NAME" = CURRENT_SCHEMA AND "TABLE_NAME" = N'PMX_AUDI' ---> System.Data.Odbc.OdbcException: ERROR [S1000] [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;258 insufficient privilege: Detailed info for this error can be found with guid '8DF930A66023384B923AC6828475EA68'

Such errors indicate that the user setup in the Produmex Suite installer does not have proper authorization on database objects. In order to troubleshoot you can use the following method to find out what is missing and how to grant the missing privilege.

SAP Official Help:

https://help.sap.com/docs/SAP_HANA_PLATFORM/6b94445c94ae495c83a19646e7c3fd56/d26bddb8bba54e2eac09d85c93aa8d1c.html?version=2.0.04

call SYS.GET_INSUFFICIENT_PRIVILEGE_ERROR_DETAILS ('<GUID in "insufficient privilege" error>', ?)

Use the built-in procedure GET_INSUFFICIENT_PRIVILEGE_ERROR_DETAILS to find out which privilege a user is missing when he or she gets an "insufficient privilege" error.

Please remember always check the Installation guide for our products because it contains useful details about the Prerequisites.