How to Deactivate (and Activate) SYSTEM User in HANA DB

It is recommended and be the best practice to deactivate the usage of SYSTEM user in the SAP HANA database. Especially, on your production system. Before you can execute the activity, your ID must have system privilege USER ADMIN.

It is just one simple line command. Execute below command. The SYSTEM user can no longer be connect to the SAP HANA database.

ALTER USER SYSTEM DEACTIVATE USER NOW

In the event of SAP support package upgrade (Enhancement, SUM usage), you may require to use SYSTEM user. You may need to re-activate the SYSTEM user for the temporary use. Execute below command.

ALTER USER SYSTEM ACTIVATE USER NOW

You May Also Like

Leave a Reply?