In your SAP HCP Trial account’s cockpit go to
Databases & Schemas under
Persistence folder and check if you have database of the system type
HANA MDC (<trial>) already may be from some earlier work. If you have, then please go to step 2 of this tutorial.
If you do not have HANA MDC instance, then follow these steps to create the instance and to assign required roles to
SYSTEM user. This will take about 10 minutes.
In your SAP HCP Cockpit go to
Databases & Schemas and click New.
HANA MDC (<trial>) as the Database System. Pick the Database ID for your instance - it should be all lowercase, only letters and digits.
Choose a password for the user
SYSTEM. Please note it down, as you are the only one who is going to use it, and there is no way to reset it if lost.
Now your SAP HANA MDC instance is being built, and this will take 6-10 minutes. You should see a message
Database started successfully on the Events screen for the instance.
Now two more steps need to be done to give your
SYSTEM user administration and developer roles. Never give the same user administration and developer roles in real-life productive scenarios!
Go to the Overview page of your db instance and click on
Administration Tools: SAP HANA Cockpit.
Logon as user
SYSTEM with the password you provided during the instance creation.
First time you logon as a
SYSTEM the information screen pops up saying your user has no administration authorizations yet. Just click OK on this and Continue on the next pop up.
Once the SAP HANA Database Administration screen is open, click on Manage Roles and Users to open Security Workbench.
SAP HANA Web-based Development Workbench: Security opens in the new browser window. Expand Users, click once on SYSTEM user, and click green plus icon to add roles to the user.
Search for roles containing
develop in names, select all of them and click OK to add them to Granted Roles.
Ctrl+S or click
Save icon. Now your
SYSTEM user has developer roles assigned. Again, never do this in productive systems!
Close Security Workbench and SAP HANA Database Administration screens and move to the next step.