I've experienced this issue as well on macOS.
When I allow some website permissions e.g. notification, microphone, camera, etc. Opera will remember not for so long. The next day Opera will ask again when to enter the websites and need those permissions.
I checked on the Settings menu on Opera and all of the saved website permission settings disappeared.