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