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: