Summary

This article explains how to reset a user's password in the database for FlexNet Operations On-Premises when the user is unable to do so through the standard interface.

Overview

If a user is logged out of FlexNet Operations and cannot reset their password via the portal, follow the steps below to reset their password directly in the database. This process will reset the user's password to "admin".

Steps

1. Retrieve the Extended Property Set ID—Run the following query, replacing <username> with the actual user ID:

SELECT Extendedpropertyset_id from PLT_USER
WHERE USERID = '<username>';

2. Find the Property ID—Use the 'Extendedpropertyset_id' from the previous select statement and add it to the 'BELONGSTOSET_ID' in the select statement below:

SELECT ID from PLT_EXTPROP
WHERE BELONGSTOSET_ID = 'addExtendedpropertyset_id' and METADATA_ID = '1';

3. Update the Password Value—Use the 'ID' from the previous select statement and add it to the 'ID =' in the update statement below:

UPDATE PLT_EXTPROP
SET TEXTVALUE = 'MD5,Base64:ISMvKXpXpadDiUoOSoAfww=='
WHERE ID = <ID number>;

The user can now log in to FlexNet Operations using their username and the password "admin".