How to Reset the Mart Administrator Password
There are a few ways to reset user passwords described below. Ideally users have configured SMTP and can reset using the Mart Administrator UI. If not, there are backend adjustments that can be made as well.
Steps:
Please follow the below steps to reset a user password…..
1- If SMTP Settings are configured in the Mart:
a- In Data Modeler, open the Mart Connection dialogue
b- Click the 'Forgot Password" link
This can also be done from the Mart Administrator console:
c- The end user will then receive an email which can be used to reset their password
More information on configuring SMTP settings here:
2- If SMTP Settings are not configured in the Mart, an Admin user can reset the password.
a- Navigate to the "User Management" page
b- Select the user and click "Reset Password"
c- The password is reset to the value defined on the "Settings" page. By default "Erwin123"
3- On the backend you can also...
a- Promote a existing user to Administrator
i. Get the userid of the user that you want to promote to be an administrator using:
select userid from m9user where username = 'username'
ii. Update the userid returned using:
Update m9profileassignment set P_Id = 3 where userid = <userid>
b- Reset the username and password for an administrator user
i. Run the following two queries:
Update m9User set Password =‘98797560f7066b618752dcf5ef5449d4e131919dabd62f44d630b65ec62123fe’ where userid=1;
Update m9User set Username ='martadmin' where userid=1;
ii. Login to Mart using username "martadmin" and "martadmin"
Please note that the username must also be updated as all password in Mart are encrypted using the username. Also, in some cases, the admin user may have a different userid.
