We have four separate environments for most databases: development,
development test, QA and production. Developers have permissions in the
development, and development test, databases to create and drop objects,
change any data they want, etc, but do not have server level permissions.
The QA and production environments are pretty much off-limits to developers
except as users. Giving most developers more permissions than this is
asking for trouble. Its not that you can't trust them. Its that many don't
known what it is they don't know, and do stupid things out of ignorance.
Frankly, even giving them the permissions they have in development and
development test sometimes causes problems. In my experience, most
developers do not know much about database design, and if you don't catch
the problems early, you have to live with them.
Received on Tue Jun 02 1998 - 23:08:15 CDT
