Skip to Content
1
Nov 03, 2022 at 12:22 PM

Unable to Drop Tables in run time post every Deployment (Due to Change of Run Time User)

346 Views Last edit Dec 22, 2022 at 06:25 AM 2 rev

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