How to create a System on SAP HANA Studio and How to create a User on SAP HANA Data Base

[Former Member]

Step by step procedure to Add or to create a System on SAP HANA Studio?

Step1: Please log on to your system -> select Windows start button -> Select SAP HANA Studio as shown given below screen.

Step2: This is the first screen, when we open the SAP HANA Studio.

Step3: Please go to Navigator Block as shown in the given below screen. Here we can add number of systems to connect different environments.

Step4: Please specify the Host Name, Instance Number and Description as shown given below.

Step5: Please provide log in credentials as per given below screen shot and click on FINISH to complete the task.

Step6: Now we have successfully created the system in SAP HANA Studio.

Step by step procedure to create a User on SAP HANA Data Base

We can create a user using SAP HANA Studio and supports the creating of a roles which is basically a set of privileges which is generally we provide to users.

Step1: Select Catalog -> Select Authorization -> Select Users option from the Navigator pane as shown below.

Step2 :  Select Catalog -> Select Authorization -> Select Users and right click on it to create a new user.

Step3 : Log on to Admin user to create a user.

Step4 : Please provide user name and initial password.

Step5 : As soon as we click on DEPLOY button, we get an error i.e. to provide External ID as shown below.

Since we have selected Kerberos option which is used to connect external users through the integration of the MIT Kerberos network authentication protocol or through the Security Assertion Markup Language (SAML) to SAP HANA DB.

So please provide External ID as shown in the given below screen shot.

Step6 : Provide External ID as discussed in previous step.

So far,We have created the SAP HANA DB user successfully with the default role i.e. PUBLIC Role as shown in the given below screen shot.

Step7 : Default Role in SAP HANA Database is "PUBLIC" and we can also add new roles to existing users as shown here.

Thank you.