Help needed to find all the objects owned by SYSTEM user in Hana DB

[bshanu123]

Hi All,

We are migrating Hana DB on-premises to Hana cloud and we have pre-requisite that SYSTEM user is not available in Hana cloud and before we migrate the users we have move the ownership from SYSTEM user and dropped the ID. how we can get all the objects owned by the SYSTEM user and how to transfer the owner from SYSTEM ID to new user ID?

Thanks & regards

Shanu

[bshanu123]

Adding to above

when i checked there are different types of object owned by system user in Hana studio. Below are the types of objects owned by system. Need help in how to change the ownership from SYSTEM user for all these objects?

OBJECT_TYPE

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

Thanks & Regards

Shanu

[bshanu123]

Thanks Michael, I got the ownership details.

Could you please advice how to change ownership for schema, objects which are owned by SYSTEM user.

THANKS & REGARDS

Shanu

[Cocquerel]

you can query the system view SYS.OWNERSHIP