In this document, I will explain how to create users, granting role to user, assigning Privileges and other functionality that comes under the User Management in SAP HANA.
1. Launch the SAP HANA studio.
2. In the navigator, select Security and choose Users.
3. From the context menu, Right click on Users and choose NEW
4. Specify the Username and Authentication information
5. You can grant roles and privileges (SQL/Object privileges, Analytic privileges, System privileges and Package privileges) to user.
To assign privileges, choose the
button. Type a name to find a catalog object (e.g Sulabh, Efashion Tutorial, _SYS_BI/_SYS_BIC, _SYS_REPO).
SQL Privileges
SQL Privileges are used to restrict access to and modification of database objects, such as tables. Depending on the object type (for example, table, view), actions (for example, CREATE ANY, ALTER, DROP) can be authorized per object. SQL Privileges are assigned to users and roles.
System Privileges
System privileges are used for performing system – level operations or administrative tasks. System Privileges are assigned to users and roles (User Admin, Role Admin, Data Admin, Backup Admin, Data Import/Export, Schema management and others)
Package Privileges
Package privileges are used to restrict the access to and the use of packages in the repository of the SAP HANA database. Packages contain design-time versions of various objects, such as Analytic, Attribute, and Calculation Views as well as Analytic Privileges and functions. To be able to work with packages, the respective Package Privileges must be granted.
On the appropriate package privilege tab. To assign privileges, choose the
button. Type a name to find a catalog object (e.g Sulabh, Root package).
Analytical privileges
Analytical privileges are used to restrict the access for read operations to certain data in Analytic, Attribute, and Calculation Views by filtering the attribute values. Analytical privileges can only applied at the processing time of the user query. Analytic Privileges need to be defined and activated before they can be granted to users and roles.
On the appropriate analytical privilege tab. To assign privileges to user, choose the
button. Type a name to find a catalog object.
6.
Grant role to User
Switch to tab Switch to tab “Granted Roles” in User Editor. To assign roles to user, choose the
button. Start typing the role name as well add the role Allow/disallow granting the role.
7. Choose on deploy
to save user in SAP HANA system.
Sulabh Bartaula
SAP HANA certified consultant
+358 40 4163 717
sulabh.bartaula@sapfox.com
