Hi, I'm learning about Oracle db and I'm stuck with a problem.
I've created a master and work repository in my PDB (called "orclpdb") with RCU using the standard user DEV_ODI_REPO.
When I connect to the repository using ODI, I can only do it with DEV_ODI_REPO. Same thing happens when I try to connect to "orclpdb" with SQLDeveloper.
It all works fine, since the tables that I create in SQLDev are shown in ODI.
But here is the problem. I need to load some data on the db and then do a mapping of the tables, but DEV_ODI_REPO is not listed in all_users so I can't grant it any privileges that it needs.
I can connect to the repo only as DEV_ODI_REPO, but I can't use that user to load the data that I need in the repo.
Thank you for your help. I'm sorry, but being new to this maybe I'm doing a stupid mistake.