cancel
Showing results for 
Search instead for 
Did you mean: 

Error in Explorer database for truncate command

08-14-2026 2:43 PM
faustocinaglia Newcomer
20 views 0 comments
0 Likes
SAP Managed Tags
Subscribe

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

0 Likes

Accepted Solutions (0)

Answers (0)