zoneminder/db/zm_update-1.37.48.sql

UPDATE Monitors SET ControlAddress='' WHERE ControlAddress='user:port@ip';

ALTER TABLE Users MODIFY `Monitors` enum('None','View','Edit','Create') NOT NULL default 'None';
UPDATE Users SET Monitors='Create' WHERE Monitors='Edit';