Showing results for 
Search instead for 
Did you mean: 

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


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

Accepted Solutions (0)

Answers (0)