HANA User Setup in Production Environment
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.