SAP HANA Cookbook

Assigning roles to users

Roles created can be assigned to users, thus providing authorization to users for objects/data. In this recipe, we will see how to assign roles to users.

Getting ready

In order to assign roles to users, we should have roles and users created readily.

How to do it…

We will be assigning roles to users as follows:

1. Open the user from the Security folder.
2. From the Granted Roles tab, add a role by searching for the created role. In our example, the role is COOKBOOK_ROLE, as shown in the following screenshot.
3. Then activate the user by clicking on Deploy.
   

How it works…

When a role is assigned to a user, the privileges and other roles that ...