One option to try, would be to separate the lifecycle of the migrations per account.
You can then have one Flyway instance per account, configured with the corresponding user and only dealing with the objects of that specific account.