3725854 - Best practices for transferring object ownership before deleting a user in SAP Datasphere

Before deleting a user in SAP Datasphere, there is a risk of technical issues or disruption if the user owns objects such as replication flows, scheduled jobs, models, views, connections, or spaces. Attempting to delete a user without reassigning ownership may lead to failures in scheduled jobs, replication flows, or other managed artifacts.

Deleting a user without transferring ownership can result in:

• Loss of governance and ownership over critical analytical assets.
• Inability to maintain, modify, or troubleshoot existing objects without DW Administrator intervention.
• Increased operational effort due to manual reassignment or recreation of objects.
• Potential disruption of downstream consumers, including SAC stories, planning models, integrations, and reporting.
• Elevated risk during user offboarding, role cleanup, or landscape transitions.

SAP Datasphere

Currently, SAP Datasphere does not provide a supported mechanism to automatically transfer object ownership when deleting a user. As a result, deleting users directly may leave productive objects orphaned, creating operational risks.

1. Manual Ownership Transfer: Transfer ownership of all objects (replication flows, scheduled jobs, models, views, connections, spaces) to another user manually.
2. Use a Dedicated Technical User:

• Create a designated technical user in your identity provider (IDP), e.g., DATASPHERE_SCHEDULE_USER.
• Assign this user the SAP Datasphere Integrator role in the relevant Datasphere space, required for creating and running replication flows for e.g.

All replication flows and scheduled jobs intended to run automatically should be created and scheduled while logged in as this technical user, making it the default owner.

To request an automated ownership transfer functionality, submit an enhancement request via the SAP Datasphere Influence Opportunity portal: https://influence.sap.com/go/datasphere

Product Management will review customer requests for consideration in future releases.

Modify the Owner of a Schedule

KBA , DS-SEC-AUTN , Authentication: SSO/SAML, OAuth Client , DS-DI-DF , Data Flows , DS-DI-SCH , Scheduling and Task Chains , DS-DI-RF , Replication Flow Runtime , Problem