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 on Users, and click on New User, as shown in the following screenshot.

3. Upon doing this, a new screen appears. In this screen, give the name of the user to be created. Authentication can be provided by passwords, the Kerberos mechanism, or the Security...