General information
Forum:
Microsoft SQL Server
Hi! I just had a discussion with my boss and he thinks that a DBA (see
bellow) should not have access to the server room, he thinks also that all
Service packs and patches on the MS SQL 2000 application side should be done
by Sys admin, and even more that the Sys Admin are transfering the schema of
a database from test environment to production mode. Me I don't think that
way but I would like some comments.
Thanks Joel
Here my boss statement:
Developer/DBA takes care of the data-model and programs; this does not
require physical access.
In large installations there is DBA who does not program / develop but works
on db optimization (part of Sys. Admin group.)
Sys. Admins apply patches to all products and in addition move programs/new
data schemas to production from development / QA environments
In proper environment; Developers have no “programming” access to production
systems – in emergency they are issued “special access” by Sys. Admins.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only