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

Starting and Stopping the SAP HANA Database at OS level

Starting and Stopping the SAP HANA Database

The SAP HANA database can be started or stopped by using SAP HANA studio
or by using OS commands.

Using OS command

• Use HDB as <sid>adm
- HDB stop I HDB start

• Use sapcontrol as root
- sapcontrol -nr 00 - function Stop
- sapcontrol -nr 00 - function start
- sapcontrol -nr 00 -function GetProcessUst

On operating system level, the SAP HANA database can be started or stopped
using the commands sapcontrol or HDB

Starting SAP HANA database
Using sapcontrol
/usrsap/hostctrl/exe/sapcontrol -nr <Instance Number> - function Start

Using HDB as <sapsid>adm
/usr/sap/<SAPSID> /<Instance_Name>/ HDB start

Stopping SAP HANA database
Using sapcontrol
/usr/sap/host.ct.rl/exe/sapco nt rol - nr <Instance Number> func tion Stop

Using HDB as <sapsid>adm
/usr/sap/<SAPSID> /<Instance_Na.me>/HDB stop

Displaying process list at command line

Log on to Linux command line as root
/usr/sap/hostctrl/exe/sapcorrtrol -nr <instancenr> - function GetProcessList

Log on to Linux command line as <sid>adm
HDB info