How do I turn off Oracle password expiration?

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.


Solution 1:

alter profile default limit password_life_time unlimited;

Solution 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)