The user's database server login needs to be edited to disable the "Enforce password expiration" setting. This will basically make their current password the only one they use, without it ever expiring.
For Hosted customers please a new raise a support case and quote this Article.
For non-hosted customer:
MSSQL Studio Fix (for MSSQL sites only – not for Oracle/SQLDeveloper)
1. Open MSSQL Studio and connect to the affected database (e.g., MOSPROD, MOSREP, etc.).
📌 Note: This only applies to MSSQL sites. It doesn't apply to Oracle or SQLDeveloper databases, though you can apply a similar fix there.
⚠️ Important: Don’t enter any specific environment as you normally would for running queries.
2. On the left-hand tree structure, expand the following:
Security.
Logins.
3. Find the user's login name, right-click it, and select Properties.
📌 Note: Make sure you’ve got the correct login. You can find it in the WORKERS table using a query like:
SELECT * FROM WORKERS WHERE last_names = 'x' OR first_names = 'x'The login you're looking for will be under the column SYSTEM_USER_ID.
4. In the Properties window, stay on the General tab (top-left).
5. You'll see a tickbox labelled Enforce password expiration - just un-tick it and click OK.
Oracle in SqlDeveloper Fix:
1. In SQLDeveloper, connect to the affected database (e.g., MOSPROD, MOSREP, etc.).
2. Expand the tree on the left and go to:
Other Users (last item in the list).
3. Find the user's login name, right-click it, and select Edit User.
📌 Note: Again, make sure it’s the correct login. Use the WORKERS table to confirm:
SELECT * FROM WORKERS WHERE last_names = 'x' OR first_names = 'x'
Look for the login under the SYSTEM_USER_ID column.
3. In the Edit User window, stay on the User tab and uncheck Password Expired (user must change next login).
4. Click Apply.