Skip to Content
0
Former Member
Jan 22, 2014 at 09:50 PM

HANA repository schema cannot be seen in the HANA cloud

69 Views

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