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.

alter profile default limit password_life_time unlimited;
  • 5
    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)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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