4 Replies Latest reply on Aug 31, 2016 2:41 PM by user8034954

    Is it a good practice to use FNDCPASS ALLORACLE  to change all ORACLE schema passwords  (other than APPS/APPLSYS)  in terms of password security?


      It is our company password policy to change apps, applsys, and all other schema passwords every three months.  I have been using FNDCPASS ALLORACLE command to do it for a few years now. Yesterday, our NEW IT Manager questioned that it is NOT a good security practice to use/share the same password among 196 accounts/schemas (there are totally 196 schema other than apps & applsys in R12 EBS). That means I need to run FNDCPASS ORACLE 196 times for each schema with a different password each :-(


      I cannot imagine I need to come up with 196 different passwords every 3 months and key them into our Password Management System. I am asking your help to provide your thoughts or how you manage the password in your Oracle EBS?