![creating roles in sap hana studio creating roles in sap hana studio](https://blogs.sap.com/wp-content/uploads/2015/06/rs2hana_2_728895.png)
Custom roles allow you to define roles as per access requirement and you can add these roles directly to user profile. This is used to add inbuilt SAP.HANA roles to user profile or to add custom roles created under Roles tab. There are different types of privileges that can be added to a user profile. Once this is done, the next step is to define privileges for user profile. Some users that are, by default, delivered with the SAP HANA database are − SYS, SYSTEM, _SYS_REPO, _SYS_STATISTICS. Validity specification is an optional user parameter. It also gives an option to define validity of user, you can mention validity interval by selecting the dates. One authentication mechanism has to be specified to allow the user to connect and work with the database instance.
CREATING ROLES IN SAP HANA STUDIO PASSWORD
However, only one password and one principal name for Kerberos can be valid at any one time. Internal authentication mechanism using a password.Įxternal mechanisms such as Kerberos, SAML, SAP Logon Ticket, SAP Assertion Ticket or X.509.Ī user can be authenticated by more than one mechanism at a time. Users in the database can be authenticated by varying mechanisms − The password rules include a minimal password length and a definition of which character types (lower, upper, digit, special characters) have to be part of the password.ĭifferent Authorization methods can be configured like SAML, X509 certificates, SAP Logon ticket, etc. The specified role name must not be identical to the name of an existing user or role. You can also choose to create a restricted user. Password is applied, while saving password for a new user. New window will open where you define User and User parameters.Įnter User name (mandate) and in Authentication field enter password. To create a new user right click on User and go to New User. When you expand security tab, it gives option of User and Roles. You will see security tab in System view − To create users and roles in HANA studio, go to HANA Administrator Console. Only database users with the system privilege ROLE ADMIN are allowed to create users and roles in HANA studio.