Should developers be able to query production databases?
178
votes
20
answers
63529
views
Should developers be given permission to query (
SELECT
/ read only) production databases? The previous place I worked, the development team had the db_datareader
role; where I work now the development team can't even connect to the production instance.
One of the test instances is a copy of production restored from a production backup once a week, so there aren't any problems with developers actually seeing the data.
What good reasons are there for not allowing developers to query production (except for simply not wanting them to have access to read sensitive data)?
Asked by Tom Hunter
(2179 rep)
Jan 6, 2012, 03:57 PM
Last activity: May 28, 2024, 11:57 AM
Last activity: May 28, 2024, 11:57 AM