Is there a way to reset ERwin Web Portal built in "Administrator" to its default?
The password for " Administrator" user in the erwin Web Portal was changed by our Web Portal Administrator who is no longer with our organization, We are unable to Update the repository database using Administrator login, Is there any query that allows resetting password outside of ERwin Web Portal UI?
Below update SQL will reset the Administrator password to " Administrator".
UPDATE MIR_META_ATTRIBUTE SET VAL='7b7bc2512ee1fedcd76bdc68926d4f7b' WHERE MODEL_ID=-1 AND CLASS_ID=-4 AND ATTRIBUTE_DEFINITION_ID=265;
Once log in as Administrator , Please change the password for Administrator
Tools | Administration | click on Administrator | change password