cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

How to reset a user's password in the database for FlexNet Operations On Premise

How to reset a user's password in the database for FlexNet Operations On Premise

Summary

This article will explain how to reset a user's password in the database for FlexNet Operations On Premise.

Synopsis

If a user is unable to reset their password for any reason and is logged out of FlexNet Operations, then the following steps will allow you to reset the password.

Below are the steps to reset a user's password in the database. This will reset the password to 'admin'.

1. Get the Extendedpropertyset_id for the user running the select statement below, changing <username> to the name of the user you're using:

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

2. Take the 'Extendedpropertyset_id' from 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. Take the 'ID' from previous select statement and add it to the 'ID =' in the select statement below:

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

4. Now, you can log into FNO with the your username and the password 'admin'.

Labels (1)
Was this article helpful? Yes No
No ratings
Version history
Last update:
‎Jan 23, 2019 04:24 PM
Updated by: