I didn't say it was unrealistic it's just stupid. I have no doubt thousands of companies are not practicing good access controls to a production db, but it's not smart as seen by this post.
Prod deployments should come from a build server though and if you're deploying multiple times a day you should have a well built CI pipeline to handle it.
Remoting into a management server would still have people using an account on the management server and their personal db login credentials.
We also don't give devs write access to production and all scripts run in production are run by our DBA after they have been approved by the lead Dev, operations and the DBA.
This might be overkill for some systems, but we won't ever accidentally delete our prod data. Our system requires this level of scrutiny due to the nature of our systems.
We have to remote into a management server to access databases outside of our local dev environment. Allowing direct access to production from your development environment seems crazy to me.
It should only apply(well it shouldn't apply at all) to crimes that actually relate to crossing a border or moving stuff across a border. Like if you were suspected for tax fraud that shouldn't be subject to 4th amendment violations because you live by a border. That's my opinion I have zero clue how it works and I'm guessing the worst way.
From what I know from my linquist friends they are kicking out most of the people who can understand other languages.