Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm using Oracle for development on my local machine. The password for a bootstrap account that I always use to rebuild my database has expired.

How do I turn off password expiration for this user (and all other users) permanently?

I'm using Oracle 11g, but I don't know if the password expiration behavior is new in 11g.

share|improve this question
up vote 23 down vote accepted
alter profile default limit password_life_time unlimited;
share|improve this answer
I think the new thing in 11g is that by default, password expiration is on. When creating a new database, you are asked if you want the new, secured default or the old 10g behavior. Anyway, Randy's SQL command will switch off password expiration for all users (unless you specifically added a profile with that limit to their profile). – Ofir Manor Jul 8 '09 at 12:33

One way to do this is to change the profile in the enterprise manager. You log on as sys/sysdba, go to Server->Profiles->Default->Edit->Password->Expire in->Unlimited. That's it. I don't know if this will change once set Expiration Dates as well, otherwise re-set the profile on the user (in enterprise mgr again)

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.