Checking something similar to
FLUSH TABLES WITH READ LOCK but need to stop writes even when the current session where the above command issued is active.
Changing user privileges throw error to user. So thinking of any better way of freezing writes in MySQL. Any leads would be helpful.