23

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.

Josh Kodroff
  • 551
  • 3
  • 7
  • 13

2 Answers2

23
alter profile default limit password_life_time unlimited;
Randy Proctor
  • 531
  • 4
  • 4
  • 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 08 '09 at 12:33
3

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)