Skip to Content

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

HANA User Setup in Production Environment

Hello all,

I have a question on how are user IDs setup in the production SAP HANA systems.

In HANA every Standard User owns a schema in which they are free to develop any Catalog objects like tables, views, procedures, etc. If a developer or a support user has a user ID in production, nothing prevents them from creating large tables in their schema & consuming memory and impacting the operation of the system. When we setup user IDs in production, how can we prevent these users from creating their own tables in their schema?

I see HANA has the Restricted User type. But the description of this user type sounds like they are meant to be used with XS applications.

How are users setup in a typical HANA datamart/sidecar environment, where the users should not be allowed to create their own custom objects.

Please share any experience / best practices.


Suresh Devarajan

Former Member

Helpful Answer

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