SAP Datasphere Replication between Tenants

[aczeitner]

Hello Specs !

I have two tenants for Datasphere a Production and Test Systems.

I've been asked to migrate data from Prod To TEST for some testing purpose so I've created a space and mapped the Prod System from Test (also added the system to whitelist).
All in all I've a successfuly connection created with an Analysis user ready to use replication flow. 

My Problem is that when I try to run a replication flow the replication flow run on error.

The error messages like this :  insufficient privilege or this "Source setup failed due to the following error: Failed to prepare source replication artifacts due to database error. SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '40F6D4EB4460104A957A47ED58309D7E'. Please refer to SAP Note 2980489 to know which privilege is missing for the current user. Contact the system administrator for the HANA system to address the issue and then resume the replication task. CorrelationId: fa46e992-1f9a-4634-1900-daa69d271c86@26-Jan-2025 06:59:49."
So think I have issue with the user.

I've used call SYS.GET_INSUFFICIENT_PRIVILEGE_ERROR_DETAILS (<guid>, ?) but I couldn't find any error message there. And although I am system owner I cannot seems to see any option to grant higher rights for analysis user (at least I cannot find) so I am clueles how to grant the necessary rights or the necessary users for migrate data from one tenant to another)

Could you please help me out how to create user that has necessary right or grant him the necessary rights.