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
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
You are sharing a piece of nice information here. The information you have provided is genuinely instructive and significant for us. Thanks for sharing an article like this. SAP handbook pdf
ReplyDelete