EBS users differences - audit
Hi team,
I have tried to compare differences between regular database and provided EBS schemas/users in our 12.1.3. environment (database 12.1). I need this information in order to implement password change, so I'm not sure which user passwords I can alter by using FNDCPASS, and which by using "alter user" statement.
I have used this statement to see differences between these two groups of users :
select username from dba_users
where username not in (select oracle_username from FND_ORACLE_USERID)
and default_tablespace='APPS_TS_TX_DATA'
order by username;
Now my problem is that I have around 26 EBS schemas which do not exist in FND_ORACLE_USERID like ABM, AHM, AMF, CSS, CUE, CUN, EAA etc. And I have read documentation where those schemas are part of EBS.