IAM Database User Account Management

This document describes the process for resetting a user account password in the IAM databases.

Step 1: Authenticate to the database where the password needs to be reset. 

Step 2: Run the following SQL command, replacing [username goes here] with your user account name and replacing [password goes here] with your new password:

Example: To reset the user scott password to tiger you would run:
ALTER USER scott IDENTIFIED BY "tiger";

Step 3: Success! Your password has been reset.

Step 4: Update your password within your application to match. 

NOTE: If you are resetting your password in PHEXPP or PHEXPT, you need to make sure you are resetting your password in both databases (PHEXPP1 and PHEXPP2, or PHEXPT1 and PHEXPT2), there is no replication between databases.


If you run into issues or have any questions about this process, please contact mstsupport@doit.wisc.edu.



Keywords:
IAM Database User Account Management password reset 
Doc ID:
137973
Owned by:
Cora B. in Identity and Access Management
Created:
2024-06-17
Updated:
2024-06-17
Sites:
Identity and Access Management