Symptom
You'd like to perform a selection deletion on tables in SAP Datasphere.
Environment
SAP Datasphere
Reproducing the Issue
CALL "DWC_GLOBAL"."GRANT_PRIVILEGE_TO_SPACE" (
OPERATION => 'GRANT',
PRIVILEGE => 'DELETE',
SCHEMA_NAME => 'SCHEMA_NAME',
OBJECT_NAME => 'TABLE_NAME',
SPACE_ID => 'SPACE_NAME')
DELETE FROM "SPACE"."TABLE" WHERE clause;
Resolution
Selective deletion on Local Tables was delivered in SAP Datasphere Wave 2024.20.
For details check SAP Datasphere Help Performing Data Deletion for Local Tables.
Keywords
insufficient privilege could not execute , KBA , DS-DI-DM , Data Maintenance , Product Enhancement
Product
SAP Datasphere all versions