There should always be an audit trail. If i made a mistake and ship bad code it isn't anyone's fault but mine. It can be verified via source control. DBs are no different. Anyone with access to prod has their own login which will show in the logs. Companies that fire people because they made mistakes will end up being a blame-game cluster fuck and their IT dept will die. Shit happens, fix it and move on. Nobody benefits (certainly not the company) if we spend more time pinning blame on someone than restoring from backups or doing a midnight bugfix release. Let's just try to do better next time.
If management is clueless then that is telling me that they are literally hiring clueless people to work there. Abandon ship. If people are intentionally sabotaging production then serve up some logs and have the saboteurs outed for what they are. That sounds really crazy. I would be stressed out if someone was intentionally trying to break production.