HANA repository schema cannot be seen in the HANA cloud

[Former Member]

After I migrate a HANA XS project from a development HANA system to the HANA cloud XS instance, I was unable to see the schema generated from my project in the catalog.

After checking the HANA developer guide p.145, executing the following SQL statements results errors.  I am confused which user name I should use (either the db tunnel user or the cloud account user) and neither worked.

Any idea?

call
_SYS_REPO.GRANT_SCHEMA_PRIVILEGE_ON_ACTIVATED_CONTENT('select','FLASH','DB tunnel user name');

Could not execute 'call ...'

SAP DBTech JDBC: [258]: insufficient privilege: Not
authorized

call _SYS_REPO.GRANT_SCHEMA_PRIVILEGE_ON_ACTIVATED_CONTENT('select','FLASH','Account user name');

Could not execute 'call _SYS_REPO.GRANT_SCHEMA_PRIVILEGE_ON_ACTIVATED_CONTENT('select','FLASH','p1940206597')'

SAP DBTech JDBC: [258]:
insufficient privilege: Not authorized

[former_member187729 · Accepted solution]

Hi Vivian,

when using SAP HANA Cloud Platform on Trial, you are working in sandbox - your development user has limited privileges. To grant select/execute privilege on some activated objects you can use stored procedures that we provide - https://help.hana.ondemand.com/help/frameset.htm?2cb80530a7a748f792050730782f9bef.html

End to end scenario is described in the blog http://scn.sap.com/community/developer-center/cloud-platform/blog/2013/10/17/8-easy-steps-to-develop...

Creation of custom schemas is not supported yet. You should use development schema that is assigned to your development user - prefixed with NEO_.

best regards

Stoyan

[bernd_hofmann]

Hi Vivian,

the tunnel user (DEV_*) is only used to establish the tunnel. For the application, your HCP account user is relevant (the one you use to log-in to your account when you access e.g. hana.ondemand.com or hanatrial.ondemand.com). So this is the one you have to grant permissions.

Did you follow the tutorial Creating an SAP HANA XS Application? It might answer some of your questions.

Best Regards,

Bernd