How to Copy a User in SAP HANA

This article answer the following query:

• How to create a copy of User in SAP HANA?
• What kind of authorization is required to create copy user in SAP HANA?

Copy a User in SAP HANA: 

It is not easily possible to copy a user with related catalog roles. We can copy a user based on SAP HANA Repository. When we create copy user, All the repository roles will be assigned to newly user automatically. You can copy a role in this way using SAP HANA Studio.

Prerequisite: 

User should have System privilege User Admin and object privilege Execute on Grant_Activated_role.

Steps for Copy User in SAP HANA:

Step 1: Open HANA Studio and login in your HANA system

Step 2: In System Views, Choose Security -> Users.

Step 3: Right-click the User to be copied and choose Copy User.

The Copy User editor opens. The repository roles granted to the source user automatically appear on the Granted Roles tab.

Step 4: Enter the required user-specific information, that is, user name and authentication details.

Step 5: Grant any additional roles and privileges required by the user.

Step 6: Create the user by choosing the Deploy (Deploy) button to create the user.

The user is created and appears in the Users folder. A new schema is also created for the user in the catalog. It has the same name as the user.

Cheers!!