I have tried the above methods, but feels like repetitive action when creating the view. I got the same issue while updating the views of the imported database.
You can simply overcome the issue in LOCAL by simply creating the User with the create privilege.