I am trying to create play around with HANA XS by following the blog by @SIMMACO FERRIERO at How to create a new OData service using the Web-Based Workbench (v2.0) and facing a road block at the step to get the schema name with below SQL commands
What i have done earlier :
Created a HCP account and created MDC with name dev as below.
Assigned the roles as in here for SYSTEM user. Link for Roles : SAP HANA Cloud Platform
Database SystemHANA MDC (<trial>)
Web Access ENABLED
Executing the above SQL statement is throwing the below error that schema is not available. Did the process of getting schema name change in MDC? .
Could not execute 'SELECT SCHEMA_NAME FROM "HCP"."HCP_DEV_METADATA"' Error: (dberror) 362 - invalid schema name: HCP: line 1 col 24 (at pos 24)