I'm using Oracle for development. 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, which has passwords expire by default.
I believe that the password expiration behavior, by default, is to never expire. However, you could set up a profile for your dev user set and set the PASSWORD_LIFE_TIME. See the orafaq for more details. You can see here for an example of one person's perspective and usage.
Open documentation http://www.oracle.com/pls/db111/homepage http://www.oracle.com/pls/db111/to_pdf?pathname=server.111/b28286.pdf for syntax for create user and alter user. I think there will be a way to disable password expiration.