Hi Folks,
I am attempting to debug a Java CAP tutorial application and I am trying to figure out how i can access the HAHA Cloud DB tables for the bookstore application. I have created the "bookstore-hana" SAP HANA Schemas & HDI Containers instance
I would like to know where I can access the HANA DB user credentials that were used to create the tables. This will enable me to run SQL against the tables either directly using the credentials or by granting another user object access.
Noter i have tried the _DT and _RT credentials but these don't appear to work i get the following error for both
Could not execute 'CONNECT 4DB18B250179468C........B8FZYKEA7T58I9_DT PASSWORD ...'
Error: (dberror) [257]: sql syntax error: incorrect syntax near "-": line 3 col 86 (at pos 87)
James
PS another suggestion that enable me to use SQL to interact with the CAP generated HANA tables directly using SQL are also really welcome.