Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

objects owned by a user in HANA

Hi Folks,

I have a question is there a way to get to know what all objects are owned by a particular user.

I was trying to drop one of the users and i am getting a message to use the cascade option. But before doing it i want to know what all objects are owned by the user so that i can take a call to drop the user.

Is there any view which gives this information.

DROP USER - SAP HANA SQL and System Views Reference - SAP Library

Former Member

Thanks for that Amerjit!

Good job answering the question.

Cheers, Lars

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question