+14Hi,
I can login to the application as IFSAPP and work without issue, but I can't use the same credentials to login to the DB.
IFSAPP is not in the dba_users table either.
How can we resolve the issue?
I need to run SQL queries against the database that the application is using.
I logged in as Sys and tried as ifsapp.XXXXX, but it also wasn't working.
Best answer by Sajith D
Hi
Any chance that the APP owner in the environment you are checking is not IFSAPP or you are connecting to the CDB instead of the PDB when you are connecting directly to the database?
Cheers
Hi
Any chance that the APP owner in the environment you are checking is not IFSAPP or you are connecting to the CDB instead of the PDB when you are connecting directly to the database?
Cheers
+14Hi
Any chance that the APP owner in the environment you are checking is not IFSAPP or you are connecting to the CDB instead of the PDB when you are connecting directly to the database?
Cheers
Hi Sajith, I used the CDB instead of the PDB. Thanks.
What is the distinction between the two?
Hi
CDB is merely a container where as PDB is the database that contains all the schema objects (App owner and all other schemas that we create). When we deploy the instances we always connect to the PDB service than the CDB service.
Cheers
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
