How can we limit the HANA memory usage of a statement executed by the single user?
The limit of SAP HANA memory usage can be set in the User Editor in HANA studio or also by using command maximum memory (in GB) that can be used by a statement executed by single user directly in the HANA studio.
Go to HANA studio
Now use below command
ALTER USER <db_user_name> SET PARAMETER STATEMENT MEMORY LIMIT = '<maximum_memory_allocation_in_gb>'