Hi, I'm learning about Oracle db and I've a problem.
I created a repository for my db using RCU. The schema owner is the standard DEV_ODI_REPO. I can create a connection to the repo (PDB) with DEV_ODI_REPO; same thing with a connection in SQLDeveloper.
I now need to grant it some privileges, but when I try to do it (using a sysdba connection), SQLDeveloper gives me an error saying that the user (DEV_ODI_REPO) doesn't exist. I don't understand what's wrong, since I can create a connection in SQLDev to the PDB using DEV_ODI_REPO. I get the same error with every query that involves DEV_ODI_REPO.
Can you please help me? Thank you a lot.
(Maybe it's something stupid, but, as I said, I'm new to this)