So I've worked in many different workplaces as a developer and my level of access to the database has been varied. I typically don't have production db access. Most of the time I have access to the test database, but it varies. Sometimes I can do and change database and data as I please, but usually there are other arrangements. Like I may only have read access to the data.I worked in one place where a DBA team would manage the databases, we couldn't make changes at all unless we submitted a form with the sql script for them to inspect. They typically didn't have much to do with the project itself so most of the time, it was just to press F5.Honestly, I can understand why prod needs to be locked down but I prefer to have as much database access in the dev and test environments. I think most devs are reasonably capable of knowing their way around a database. But I would like to hear opinions though? How much database access should developers have? Can we be trusted to not break anything up there?
How much database access should developers have?
database;security;access