Creating users

User IDs are required to log in to a SAP HANA database. This recipe is all about creating users. Let us see how to create users in SAP HANA Studio.

Getting ready

Only database users with the USER ADMIN system privilege are allowed to create another database user. The name of the user should not be the same as the existing user/role/schema. For example, a few users such as SYS, _SYS_BIC, SYSTEM, and _SYS_REPO are delivered with SAP HANA.

How to do it…

We can create user IDs in two ways: using the GUI method in SAP HANA Studio or using the SQL code. This recipe is about creating users by the GUI method.

Let's follow the given steps:

  1. Expand the Security folder in the system where a user has to be created.
  2. Expand the Users menu, right-click ...

Get SAP HANA Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial