Error in Explorer database for truncate command

faustocinaglia — Fri, 14 Aug 2026 12:43:19 GMT

Hello everyone,

We need to physically delete data from certain tables (which are targets of various replication flows) located in a SAP HANA data lake file space, please, how can this be done?

Indeed I tried granting privileges on two tables:
- one virtual GRANT TRUNCATE ON "QDSP_ISU_DL"."ISU_IDTR_ZDMTB_TEST_CDSV" TO DWCDBUSER#DMA; which returns the following message.

Could not execute 'GRANT TRUNCATE ON "QDSP_ISU_DL"."ISU_IDTR_ZDMTB_TEST_CDSV" TO DWCDBUSER#DMA'

Error: (dberror) [460]: invalid privilege for object: Cannot grant privilege TRUNCATE on virtual table ISU_IDTR_ZDMTB_TEST_CDSV: line 1 col 32 (at pos 32)

- one real GRANT TRUNCATE ON "QDSP_ISU"."TABELLA_DI_TEST_PER_TRUNCATE" TO DWCDBUSER#DMA; which returns the following message

Could not execute 'GRANT TRUNCATE ON "QDSP_ISU"."TABELLA_DI_TEST_PER_TRUNCATE" TO DWCDBUSER#DMA'
Error: (dberror) [334]: invalid user privilege: TRUNCATE: line 1 col 6 (at pos 6)

Thank you for your answer

Fausto

Re: Error in Explorer database for truncate command

cardoso — Tue, 18 Aug 2026 14:41:22 GMT

Hi @faustocinaglia,

Refer to Delete Data From Your Local Tables (File).

BR.

Question Re: Error in Explorer database for truncate command in Technology Q&A

Error in Explorer database for truncate command

Re: Error in Explorer database for truncate command