SAP HANA – some _SYS* users are deactivated
Today’s question… Some _SYS users in HANA 2.0 system are deactivated. This is normal situation??
| USER_NAME | USER_MODE | EXTERNAL_IDENTITY | CREATOR |
|---|---|---|---|
| _SYS_AFL | LOCAL | ? | SYSTEM |
| _SYS_DATA_ANONYMIZATION | EXTERNAL | ? | SYS |
| _SYS_EPM | LOCAL | ? | SYS |
| _SYS_PLAN_STABILITY | EXTERNAL | ? | SYS |
| _SYS_REPO | LOCAL | ? | SYSTEM |
| _SYS_SQL_ANALYZER | LOCAL | ? | SYS |
| _SYS_STATISTICS | LOCAL | ? | SYS |
| _SYS_TABLE_REPLICAS | EXTERNAL | ? | SYS |
| _SYS_TASK | LOCAL | ? | SYS |
| _SYS_WORKLOAD_REPLAY | LOCAL | ? | SYS |
Answer
Yes, this is a normal situation. _SYS_* users are technical users which means You can’t simply log on with these users. You can find more information about this in the following KBA: 1966219 – HANA technical database user _SYS_REPO cannot be activated.