Deleting Developer in HANA Studo and object ownerships.

[former_member550248]

Hi Experts ,

Need your help in a query. I have gone through forums/blogs on SCN, but could not find satisfactory answer. I have a query about objects ownership and users(specially Developers) deletion in SAP Hana studio.

My understanding is when we delete a user in SAP HANA Studio in -

1. Restricted mode : Then system will check if there are any objects which are owned by someone else in user's schema/s .If there are any such objects, then user will not be deleted.

But if there are no such objects in user's schema/s , which are owned by someone else, then all of user's schema/s and underlying objects will be deleted (similar to cascade mode).

2. Cascade mode: No check is made by system. User and all the objects owned by user(whether in his own schema or in another user's schema) will be deleted.

I have gone through SAP help, various forums and this is what i understood. Please correct me if wrong here.

Now, if above is true, then will request your help in below queries,

A. Can a developer create(with his own user) a Catalog/Runtime object which gets owned by some other technical user like SYSTEM etc.?

B. Can a developer transfer the ownership of catalog objects already owned by him - to another Developer/user?

C. What process you follow while deleting(not just deactivate) a Developer from HANA Studio? How do you ensure that objects owned by him are not deleted?

I know they can create objects in repository and those will not be owned by their own user ids. Also, that developer can transfer the ownership of inactive objects in their repository workspace to another developer.

My main concern is about the Run time objects created by Developers, which are subsequently being used in some config e.g. Smart Data Access.

Appreciate the help.

[Manas_Vincit]

Hi, Did you get solution to above problem listed, If there are some best practices it is good to know.