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
Request clarification before answering.
| User | Count |
|---|---|
| 7 | |
| 5 | |
| 5 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.