The following list are the standard users and schemas which are exists in the SAP HANA database environment. You can refer to SAP Note 2535951 – FAQ: SAP HANA Users and Schemas for further and updated information.
Standard HANA Users & Schemas
| User Name | Schema Name | Area | Details |
|---|---|---|---|
| HDI_BROKER_CONTROLLER | HDI_BROKER_CONTROLLER | XSA | User for HANA service broker API |
| sap_sb | sap_sb | XSA | User for user account and authentication (UAA) broker API |
| SYS | SYS _SYS_AUDIT | Core | Owner of all monitoring views and system tables |
| SYSTEM | SYSTEM SYS_REPL _SYS_SECURITY | Core | - Initial user created during creation of SAP HANA database. - Superuser with irrevocable system privileges. |
| SYS_STREAMING | SYS_STREAMING | SDS | Smart data streaming (SDS) user responsible for granting or revoking user permissions. |
| SYS_STREAMING_ADMIN | SYS_STREAMING_ADMIN | SDS | Smart data streaming (SDS) user responsible for performing all streaming tasks (except for publishing or subscribing for streams). |
| SYS_XS_HANA_BROKER | SYS_XS_HANA_BROKER | XSA | Owner of schema for HANA service broker. |
| SYS_XS_RUNTIME | SYS_XS_RUNTIME | XSA | Owner of the controller's SAP HANA schema containing blob store / config store and secure store. |
| SYS_XS_SBSS | SYS_XS_SBSS | XSA | Owner of schema containing procedures to generate user passwords in secure manner used by the HANA service broker. |
| SYS_XS_UAA | SYS_XS_UAA | XSA | Owner of schema for user management in context of user account and authentication (UAA). |
| SYS_XS_UAA_SEC | SYS_XS_UAA_SEC | XSA | Owner of secure store for user credentials in context of user account and authentication (UAA). |
| SYS_AFL | _SYS_AFL | AFL | Owner of application function libraries (AFL) objects. |
| _SYS_DI | _SYS_DI | XSA | Owner of HANA deployment infrastructure (HDI) SQL-based APIs. |
| _SYS_DI_*_CATALOG | _SYS_DI_*_CATALOG | XSA | Used by HANA deployment infrastructure (HDI) to access system catalog tables and views. |
| _SYS_DI_SU | _SYS_DI_SU | XSA | Technical super user for HANA deployment infrastructure (HDI). |
| SYS_DI_TO | _SYS_DI_TO | XSA | Owner of transactions and connection for all internal HANA deployment infrastructure (HDI) transactions. |
| _SYS_EPM | _SYS_EPM _SYS_EPM_DATA | EPM | Owner of enterprise performance management (EPM) objects. |
| _SYS_REPO | HANA_XS_BASE SAP_AUTHORIZATION SAP_HANA_ADMIN SAP_HANA_BACKUP SAP_HANA_IM_DP SAP_HDM SAP_HDM_DDO SAP_HDM_DLM SAP_INA_FILELOADER SAP_RE T_API SAP_XS_LM SAP_XS_LM_PE SAP_XS_LM_PE_TMP SAP_XS_USAGE UIS _SYS_BI _SYS_BIC _SYS_REPO _SYS_RT _SYS_XS | Repository | Owner of SAP HANA repository objects related to SAP HANA XS classic. |
| SYS_SQL_ANALYZER | _SYS_SQL_ANALYZER | SQL analyzer | SQL statement performance analysis. |
| SYS_SR | _SYS_SR _SYS_SR_SITE_[sr_site_name] | System replication | Access to monitoring information on remote system replication sites. |
| _SYS_STATISTICS | _SYS_STATISTICS | Statistics server | Configuration alert and history information for statistics server. |
| _SYS_TASK | _SYS_TASK | SDI | Owner of smart data integration (SDI) objects. |
| _SYS_WORKLOAD_REPLAY | _SYS_WORKLOAD_REPLAY | Capture and replay | Execution of capture and replay activities and owner of the related objects. |
| SYS_XB | _SYS_XB | XB | Internal user for messaging purposes. |
| XSA_ADMIN | XSA_ADMIN | XSA | Administrative user for the XS advanced application server. |
| XSSQLCC_AUTO_USER_[id] | XSSQLCC_AUTO_USER_[id] | XS classic | Automatically generated user for SQL connection configuration in XS classic environments in case no explicit user is specified. |
Application Specific HANA Users & Schemas
| User Name | Schema Name | Application | Details |
|---|---|---|---|
| DBACOCKPIT | DBACOCKPIT | SAP ABAP | SAP ABAP installations before April 2013 used the special database user DBACOCKPIT for database connections via transaction DBACOCKPIT. Later on the standard ABAP user SAP[id] (or SAPABAP[num] see below) is used. |
| SAP[id] SAPABAP[num] | SAP[id] SAPABAP[num] | SAP ABAP | SAP ABAP schema owner; historically [id] was 'R3' or identical to the SID of the ABAP system but also any other variant like 'SR3' or 'PRD' is allowed. Default name suggestion of SWPM is SAPABAP1 (higher numbers if users with lower numbers already exist). |
| SAP[id]DB SAPJAVA[num] | SAP[id]DB SAPJAVA[num] | SAP J2EE | SAP J2EE schema owner; historically [id] was identical to the SID of the ABAP system but also any other variant like 'SR3' or 'PRD' is allowed. Default name suggestion of SWPM is SAPJAVA1 (higher numbers if users with lower numbers already exist). |
| SAP[id]SHD SAPABAP[num]SHD | SAP[id]SHD SAPABAP[num]SHD | SAP ABAP | Shadow user of SAP ABAP schema owner temporarily used during SAP ABAP shadow upgrade. Generated by extending the normal ABAP user name with 'SHD'. |
| SAP_IC | Information Composer | The technical user SAP_IC is created during installation. After installation has completed – SAP_IC is locked. As long as the SAP HANA Information Composer is in use the SAP_IC user must not be deleted because otherwise the role assignments created by this user will also be deleted. |
