Search This Blog

Showing posts with label SYSTEM user in HANA DB. Show all posts
Showing posts with label SYSTEM user in HANA DB. Show all posts

Thursday, July 23, 2020

Deactivating SYSTEM User in Sap Hana database

Deactivate the SYSTEM User

As the most powerful database user, SYSTEM isn't intended to be used in production systems. Use it to make lesser privileged users for particular purposes then deactivate it.

Procedure

Execute the subsequent statement, for instance , within the SQL console of the SAP HANA studio:

ALTER USER SYSTEM DEACTIVATE USER NOW

The SYSTEM user is deactivated and may not hook up with the SAP HANA database.

You can verify that this is often the case within the USERS system view. For user SYSTEM, check the values within the columns USER_DEACTIVATED, DEACTIVATION_TIME, and LAST_SUCCESSFUL_CONNECT