How to change the ownership for Object in SAP Hana DB

[bshanu123]

Hi Experts,

I have a requirement to change the ownership of objects owned by SYSTEM user in Hana DB. This is part of Hana cloud migration pre-requisite. we have observed that the following are types of objects owned by the SYSTEM user from Ownership view. where we need help to change the ownership from SYSTEM ID to a user ID.

OBJECT_TYPE

• SOURCE
• TABLE
• SCHEMA
• PROCEDURE
• TRIGGER
• PSE
• INDEX

Very much Appreciated quick advices.

Thanks & regards

Shanu

[HakanHaslaman]

There is an old posting, may that helps further:
https://answers.sap.com/questions/10182888/how-to-change-objects-owners-in-hana.html

[bshanu123]

Thank you!