In this, we need to provide different activities for different users.
Types of users: There are three types of uses
Business users: View results of business modelling
use client tools
Modellers: Define business models
use the information modeller of SAP HANA Studio
|If you would like to become an SAP Hana Admin certified professional, then visit Tekslate - A Global online training platform: "SAP Hana Admin training and certification course"
To liable to log on to the system, users have to be authenticated currently there are two authentication types:
Database – internal authentication with a username and password.
External authentication via a third–party authentication provider
SAP HANA database provides its own authorization Service:
All authorizations on data all handled in the SAP HANA data box
The user with which you log on to the system determines which database objects you on acumen and modify
Users can only perform operations for which they have been granted privileges
Exception: There are two default users created during installation, which have a fixed set of privileges each by default
Privileges that were directly granted to them (“Direct privileges”.)
Privileges that were granted to notes that they belong to ( inherited privileges)
Users and roles are defined inside SAP HANA DB Using HANA STUDIO
Read & Role Hierarchy
Users and their assignments to roles
|Checkout our Blog on SAP HANA Interview Questions
ROLE – ADMIN Privileges are required to create roles a newly created role is initially empty.,
The new ride name must be different from any other existing role or user name existing role or user name
Role name: Enter the role name
You can change the Role properties:
We (You) can create users and specify a user name, which is not identical to the name of an existing user or role
User name: Enter the user name
Authentication: Define whether the user authentication should be carried out intimation or externally for internal Authentication: Enter and confirm a password.
External Authentication: Enter the external ID specified in the active directory for the user.
You can grant roles (Granted Roles) and/or privileges (SQL privileges, analytical privileges, system privileges) to the user to allow the user to pass on his privileges to other users, mark the grant option
Choose to Deploy to the crate
We can change user properties for example passwords, roles, and privilege
Password: We can change the password if authentication is Internal, on the external ID if the authorization is External
Roles and privileges: We can grant roles and Revoke and/or privileges (SQL privileges, analytical privileges, system privileges) to the user
Grant Option: We can change the Grant option which allows the user to pass on his privileges to other users when setting
Select Authorization Role in the Navigation
Select the role
In the context menu, select delete
Select Authorization User in the navigator
Select the user
In the context menu, select delete.
For in-depth knowledge of SAP HANA, click on below
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
Get stories of change makers and innovators from the startup ecosystem in your inbox