SAP Knowledge Base Article - Public

3315467 - Selective deletion on local tables of SAP Datasphere

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