Can we delete session without SQL "ALTER SYSTEM CANCEL SESSION 'XXXXXX'"?
We can not execute kill session SQL because we use HEC service and we don't have the priviledge of SESSION ADMIN.
HEC answer SESSION ADMIN is not standard priviledge for customer.
When we meet error of lock entry, we need to request to hec team unlock the lock entry each time.
And this raising request and communication with HEC make the late to resolve the issue.
We would like to unlock the lock entry by ousrselves because a few hundred of the number of application member is stopped by this issue.
------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.