Symptom

Could not execute 'EXPORT REORG_LOCATIONS_EXPORT AS CSV INTO '/tmp'' SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

Solution

Execute with the same schema user and grant EXPORT in system privilege 

Hope this helps!!!

Abraham

Grant select privilege on table in sys schema

Symptom

SAP DBTech JDBC: [259]: invalid table name: REORG_PLAN_EXPORT: line 1 col 12 (at pos 11)

Could not execute 'CREATE TABLE REORG_PLAN_EXPORT AS (SELECT * FROM SYS.REORG_PLAN_)'

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

Solution

You need select authorization on schema SYS in order to execute this.

If you want to grant select access on SYS schema then you can grant SAP_INTERNAL_HANA_SUPPORT role to the user