Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

2 Answers 2

up vote 20 down vote accepted
alter profile default limit password_life_time unlimited;
share|improve this answer
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
add comment

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
add comment

Your Answer

 
discard

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.