Skip to main content

Hi,

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.


 

Hi @Darshana Herath ,

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 @Darshana Herath ,

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 @Darshana Herath ,

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

Reply


Terms & ConditionsCookie settings