You are not required to drop the database user; however, you're correct that each version of FME Flow has a different Schema. As a result, it’s recommended to drop and recreate the database to ensure compatibility with the new version.
If you have any further questions, feel free to ask.