This discussion is archived
3 Replies Latest reply: Jan 24, 2013 6:54 AM by Osama_Mustafa RSS

how to check password policy in oracle 11gR2?

985445 Newbie
Currently Being Moderated
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?

thnaks
ananda

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points