Reset multifactor authentication for a user who has already gone through the setup process


In Aeries:


Step 1: Navigate to Security > Users


Step 2: Search for and select the desired account


Step 3: Click Change

Step 4: Click Reset under the Multifactor heading




In SQL:

Step 1: Identify the UGN.UID value of the desired account

EXAMPLE

SELECT UID FROM UGN WHERE UN = 'admin'

Step 2: Set UGN.MFA to 0 and UGN.MFK to blank 

EXAMPLE

UPDATE UGN SET MFA = 0, MFK = '' WHERE UID = 1234