Home / server / Questions / 37622
Accepted
Josh Kodroff
Asked: 2009-07-09 04:01:00 +0800 CST

How do I turn off Oracle password expiration?

  • 772

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.

oracle

2 Answers

  1. Best Answer
    alter profile default limit password_life_time unlimited;
    • 23

  2. 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)

    • 3