Ok, I could now grant the privileges by SQL at first.
GRANT CREATE VIRTUAL TABLE, DROP ON REMOTE SOURCE "Name" TO "IDContainer_HDI_CONTAINER#OO";
(You have to be sure, that the owner of the remote source is the same one as the grantor.)
After that I was able to build the file .hdbvirtualtable.
VIRTUAL TABLE "TBASE.db.data::vtName" AT "Name"."<NULL>"."<NULL>"."ABAPTABLES.Name"
I'm still not able to get any data from the remote source, even after I could build the .hdbvirtualtable and hdbconfiguration file.
If I want display the data, I get this error: "Resource not found"
Any ideas what the reason is? For the remote source object (hdbconfig) I tried a lot of different ways, like
"<NULL>"."<NULL>"."ABAPTABLES.NPAT"
"ABAPTABLES.NPAT"."<NULL>"."<NULL>"
"ABAPTABLES.NPAT"@"<NULL>"."<NULL>" and so on... but nothing worked for me.
I can create the virtual table directly on this way, but it didn't help me.
CREATE VIRTUAL TABLE "TJTN3S10YLGSCRZ5_TBASE_HDI_CONTAINER"."TBASE.db.data::vtName" AT "CSP_ABAP_ADAPTER"."<NULL>"."<NULL>"."ABAPTABLES.Name"
{"TBASE.db.data::vt_Name" : { "target" : { "remote" : "Name_ABAP_ADAPTER", "database" : "ORACLE", "schema" : "SAPR3", "object" : "ABAPTABLES.Name" } } }
Add comment