SAP Knowledge Base Article - Preview

3762045 - Inconsistent activation status of user _SYS_SR between HANA studio and SYS.USERS view

Symptom

  • When checking the _SYS_SR user with an SQL query, USER_DEACTIVATED = FALSE (active).

SELECT user_name, user_deactivated FROM SYS.USERS WHERE USER_NAME = '_SYS_SR';

USER_NAME;USER_DEACTIVATED
_SYS_SR;FALSE

  • In HANA studio, the _SYS_SR user shows status "The user cannot be activated".

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

  • SAP HANA, platform edition 1.0
  • SAP HANA, platform edition 2.0
  • SAP HANA Security & User Management

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

_sys_sr, user_deactivated, status discrepancy, hana studio, deprecated tool, system replication, high availability, technical user, cannot be activated, activation status, sql check, user management, security, monitoring, cockpit , KBA , HAN-DB-SEC , SAP HANA Security & User Management , HAN-CPT-CPT2-ADM , SAP HANA Cockpit 2 (Administration Core) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.