Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DBA's Job
Message
From
06/10/2005 05:19:18
Joel Casse
Bishops University
Lennoxville, Quebec, Canada
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
DBA's Job
Miscellaneous
Thread ID:
01056650
Message ID:
01056650
Views:
64
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
Map
View

Click here to load this message in the networking platform