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".
Related Articles
How to add Customer user from LDAP domain in Flexnet Operations onprem setup 14Number of Views This Article Will Explain How to Overcome The Error: "LFSError:UNKNOWN_ERROR" in FlexNet Operations on Premise. 9Number of Views Hotfix for LDAP user login failed & webservice user locked in Flexnet Operations 2022 R1 8Number of Views How to edit entitlements and other FlexNet Operations entities in deployed state? 5Number of Views How do you trigger user-enabled email template with customized message in FlexNet Operations On-Premises 2016 R4? 3Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago