3 ms·
> You shouldn't get access to prod if... Well, this was back in the dark ages. Nowadays I'm sold on the notion that we shouldn't be running ad hoc stuff agains
by dcminter 5y ago
> You shouldn't get access to prod if...
Well, this was back in the dark ages. Nowadays I'm sold on the notion that we shouldn't be running ad hoc stuff against the live prod database at all.
I'm sure there are exceptions, but I'll bet there are more temptations than solid reasons to do so!
- marcosdumay 5y agoWell, somebody has to have access to live prod. That somebody should avoid using it too. Anyway, everybody should run their queries on a prod-like environment before running on prod, but on Oracle that's really not enough. Also the places that use expensive DBMSes tend not to have a lot of non-prod environments for people to test their scripts. Nowadays Oracle supports you engineering your data so some of it is not on the bottleneck of anything and you can give some low amount of access to inexperienced people. But that's not the default situation.