Using Oracle 11g, is there a way to prevent my user's passwords from needing to be updated (ORA-28001)?
The expiration of passwords in Oracle is controlled by the profile that is assigned to the user. You can see which profile is assigned to each user by querying the DBA_USERS table
You appear to be hitting the
Of course, if the first query indicates that your users are assigned a profile other than DEFAULT, you'd want to alter that profile instead.
If you're interested in what other behaviors a profile controls, the CREATE PROFILE documentation is quite useful.
I have gotten burned so many times that I set them all with:
set pages 60 select * from dba_profiles where profile='DEFAULT'; alter profile default limit FAILED_LOGIN_ATTEMPTS UNLIMITED; alter profile default limit PASSWORD_LIFE_TIME UNLIMITED; alter profile default limit PASSWORD_GRACE_TIME UNLIMITED; alter profile default limit PASSWORD_LOCK_TIME UNLIMITED; select * from dba_profiles where profile='DEFAULT';