Recover a locked Root User account

If the root account becomes locked, to unlock it you will need access to the underlying database that stores all of the Registry information.

In the database there will be a table with the name 'registry_root_security'.

This table contains the following information about the root account: the username; the password (encrypted); the number of times a wrong password can be entered before the account is locked; whether or not the root account is locked.

To unlock a locked root user set the value of the column 'is_locked' to 0. There is no need to restart the Registry after this change, the root user is now unlocked.