Home > IT Answers > Database > dba deleting data
Biker01
5 pts.
 dba deleting data
Database Administrator, DBA, SQL scripts
Is part of a DBA's job to delete production data using SQL scripts?

Software/Hardware used:
ASKED: July 7, 2009  7:49 PM
UPDATED: August 26, 2010  2:29 PM
RELATED QUESTIONS
Answer Wiki:
It can be, provided that the request is sent through the normal approved change process. If a developer walks up to you and asks you to delete data from a table, then its probably not an approved change. However if that request comes to you through the proper change control procedures then yes. No one should fault you for questioning the running of the script. But once you are sure that it's been approved then yes.
Last Wiki Answer Submitted:  July 8, 2009  1:07 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Mr Denny’s answer is correct. I would add that if you are asked repeatedly to delete data from the same tables then this function needs to be added to the application system.

Meandyou
 5,205 pts.