I saw an interesting post on Niall's blog this evening titled "DBA as User". This is an interesting discussion started on AskTom and continued by Niall in his blog post. The question is should DBA's alter and meddle with data in the database? - this is a controversial one. If the data is corrupted and the business is down then most likely it will happen that the DBA will fix the data. I can understand Tom's view that DBA's should not alter the application data just the same as a DBA should not alter the dictionary. This is a good discussion on AskTom and also in the comments on Niall's blog.
I agree with the no action lobby, the data should not be altered under any circumstances unless it is a last resort. There should be audit and constraints in place. Altering data without detailed knowledge of its structure and schema can cause more issues than are fixed. I can see that last resort cases occur when data has to be fixed but this should be done by consultants who understand the schemas and also the business. Ideally the applications and API's should be used to fix data not DBA's with SQL.
good post!
Blog
Pete Finnigan's Oracle Security Weblog
This is the weblog for Pete Finnigan. Pete works in the area of Oracle security and he specialises in auditing Oracle databases for security issues. This weblog is aimed squarely at those interested in the security of their Oracle databases.
[Previous entry: "The slashdot effect can be a problem for other sites"] [Next entry: "Frappr is mapping Oracle bloggers"]
January 2006
- Niall has a good post - DBA as User - 01/05/2006 by 01/05/2006
- up front security - 01/06/2006 by 01/06/2006
- A tiny digital camera - 01/07/2006 by 01/07/2006
- Oracle 'Worm' Exploit Gets Ominous Tweak - 01/08/2006 by 01/08/2006
- Justin talks about a new series of papers on Oracle security by Arup - 01/09/2006 by 01/09/2006
- Howard has some good advice on protecting against worms - 01/10/2006 by 01/10/2006
- Doug has posted an intersting note about executing of SQL script from URL's - 01/12/2006 by 01/12/2006
- Oracle is finally listening to customers about fix times and security patch quality - 01/14/2006 by 01/14/2006
- Interview with Oracle's security chief - 01/16/2006 by 01/16/2006
- Red Database Security has released 5 Oracle security bug advisories - 01/17/2006 by 01/17/2006
- Alex has added advisories for 23 security bugs fixed in 10g Release1 - 01/19/2006 by 01/19/2006
- Alex has produced a detailed analysis of the Jan 2006 CPU - 01/22/2006 by 01/22/2006
- Duncan Harris speaks on Oracle Security - 01/24/2006 by 01/24/2006
- Oracle is advising customers to patch the last CPU very quickly - 01/25/2006 by 01/25/2006
- An argument rages in the ePress between Oracle and Litchfield - 01/27/2006 by 01/27/2006
- Gartner: Oracle no longer a bastion of security - 01/30/2006 by 01/30/2006
- How to connect to the database using Perl - with two way communication - 01/31/2006 by 01/31/2006
Archives
Syndication
Powered by gm-rss 2.0.0
