Restrict schema size

[Former Member]

Hi everyone,

Just wondering if there is a way in HANA to restrict the size (memory allowance) of a particular schema? We have some users that can create objects but want to be able to set a limit on the size of the tables they can create.

Regards,

Mark.

[lbreddemann]

As schema is an object namespace and not a ownership construct, size limitations based on the schema doesn't make really make sense.

Beyond that, SAP HANA currently (SPS8) does not provide options to limit the amount of data storage on a user base.

- Lars

[Former Member]

Hi Lars,

Thanks for the reply. I was actually looking for a way to restrict the amount of storage based on a user, but if that's not possible then that is how it is.

Thanks,

Mark.