3 Replies Latest reply on Jan 24, 2013 2:54 PM by Osama_Mustafa

    how to check password policy in oracle 11gR2?

      Hi friends,

      I have faced problem on export backup failed due to user : SYSTEM password was expired... Even application user pw was also expired.

      After that reset the existing password then export was taken successfully..

      Please give me script for pw policy checking as below.

      1. How to check pw policy?
      2. How to disable pw policy?
      3. how to enable pw policy?
      4. how to verify disable or enable pw policy?

      In production server, Is it best pratices for disable pw policy?


      Edited by: 982442 on Jan 24, 2013 4:03 AM