We have Fiori Application where a User will be able to create Tables dynamically in SAP HANA Cloud, So during the Table Creation the RT User transfers the ownership to a Restricted User <Schema_name>#OO and it becomes the owner of the Table that is created
So as long as there is no deployment everything works fine all operations on the table works fine
Now Post Every Deployment in the same environment there is a new RT User Created for the Application and the Because of this New RT User does not have the ownership to DROP the Tables earlier created by the Original RT User [Owner of the tables is <Schema_name>#OO User]
Is there any way we can transfer the Ownership of all the tables to the New RT User post every deployment in the same environment
Any inputs on this would be helpful