In my previous post we have created the SAP HANA Colud developer Account. Now we will see how to create HANA MDC (Row) database.
After Login to the SAP HCP Cockpit, on the Navigation Bar we have “Databases & Schemas” Click that.
Click “New” to create a database and enter the “Database ID” we can choose any name here,
Give the Password for the “SYSTEM” User, this is require to login to the Database in the next step.
Now press “Save” it will take some 15 – 20 min.
we can see the progress in the “Events” tab from Navigation bar. once the event “Database started successfully” is raised, go to the “Overview” tab.
Which look as below.
Where status is “STARTED”
Now we need to configure the Schema in the Database which we created. to do that we need the user for the same.
Lets create the Database user first, we can not use SYSTEM user for db access that’s why.
Creating DB user
Click on the “Administration Tools : SAP HANA Cockpit” link which will open the Fiori Application in new window( Which is called HANA Cockpit).
Then Give the User name as “SYSTEM” and password which is given in previous step
It will say you dont have permission, dont worry we are using Trail account we have to see these errors, click “OK”.
Now in the Fiori Lanchpad click on the “Manage Roles and Users” Tile, which will open the new Fiori app (SAP HANA Web-based Development Workbench: Security)
In the Above Screen right click on the users and select new user in the context menu
Enter the User name, Which is ALLCAPS “SAP Stranded” period, and password (Temp password once user is logged in he has to change this) and Save from the main menu as in the previous screen shot.
Add Roles user
Click on the “+” icon in “Granted roles” tab
Search of “ide” as below and select all press “OK”
Do the same to add one more role “CONTENT_ADMIN”
Yes, we have created the HANA MDC database and added the User which is having role to access and modify the database though SAP HANA Databse WebIDE
Confirm the user and roles are proper
Log out from the Security App ( yes we are working on SYSTEM user till now)
Login with the New user which is created, and temp password which is given while creating the user.
Once login it will ask to change the Password for the user.