This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- FlexNet Operations
- :
- FlexNet Operations Knowledge Base
- :
- How to reset a user's password in the database for FlexNet Operations On Premise
Subscribe
- Mark as New
- Mark as Read
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
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'.
No ratings