SYS_STREAMING, SYS_STREAMING_ADMIN, and SYSTEM user: What do they do?
There are various users you’ll need while working in SAP HANA smart data streaming, including SYS_STREAMING, SYS_STREAMING_ADMIN, and SYSTEM. But what do each of these users do? Keep reading to find out:
| Time of creation | Password | Privileges | Limits | |
|---|---|---|---|---|
|
SYS_STREAMING |
Streaming installation |
Streaming cluster manager password. Set this during the streaming installation. |
Grant or revoke existing users’ permissions in streaming. |
To view streaming tiles in HANA cockpit, you need the following role: sap.hana.streaming. monitoring.roles::Monitoring. You can’t create new users. |
|
SYS_STREAMING _ADMIN |
Streaming installation |
Same password you set for SYS_ STREAMING. |
Perform all tasks in streaming, except for publishing or subscribing to streams. |
To view streaming tiles in cockpit, you need the following role: sap.hana.streaming. monitoring.roles::Monitoring. You can’t create new users. |
|
SYSTEM |
HANA installation |
Set this during HANA installation. |
Perform all tasks in streaming. |
To view streaming tiles in cockpit, you need the following role: sap.hana.streaming. monitoring.roles::Monitoring. |
The SYS_STREAMING and SYS_STREAMING_ADMIN user can manage existing users, but they don’t have permission to create new users. To create a new user, you need to either:
- Have a user with administrative privileges, or
- Reactivate the SYSTEM user.
The SYSTEM user is typically used to set up initial users in HANA, and then is deactivated.
Keep in mind that there are no streaming-specific users; you can only create users in HANA. Once you have done this, assign permissions using the streaming tiles in cockpit. Grant users roles or permissions to perform tasks in streaming, as needed.
Related Links
For more information, take a look at our documentation for Smart Data Streaming Security, and check out our video, Setting up Streaming Permissions, on the HANA Academy.