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 ?
Below update SQL will reset the Administrator password to default password "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
Tools | Administration | click on Administrator | change password