RE: How do you feel about allowing non-DBA's on your database servers?
- From: "Clarke, Andrew" <andrew.clarke@xxxxxxxxxx>
- To: <robertgfreeman@xxxxxxxxx>, "Oracle L" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 27 Jul 2009 16:49:12 +0100
Robert
Your position is basically the correct one, and one the customer ought
to appreciate in the era of SOX and all those other tricky compliance
issues. However, the fact that the client is under this pressure
suggests that the DBAs and Sysadmin types are not being sufficiently
responsive to requests from Support and Development.
Obvious everybody is overworked and too busy these days, but if the
people who got root don't make time to help Support and Dev then they
will come under pressure to broaden access to the servers. It's not
necessarily right but it is understandable.
Having been on both sides of the fence I can assure you there are no
easy answers. The way forward is for the client needs to get
representatives from all the interested parties in the same room to
discuss it. At which meeting they'll probably discover that Development
don't want to run sar at the drop of a hat, they just need regular
(daily) profile reports , and Support needs ps running within five
minutes of asking, on average twice a week.
Cheers, APC
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Robert Freeman
Sent: 27 July 2009 16:31
To: Oracle L
Subject: How do you feel about allowing non-DBA's on your database
servers?
So, I've got a client that is being pressured by development and support
types to allow access to their database servers. They claim that it's so
they can use tools like ps, sar, topas, etc.... to monitor performance
and deal with support issues.
My position is that this is a huge risk and that I would want an very
limited population of users (read DBA's and SYSADMIN's only) to have
access to these servers.
Anyone have an opinion on this?
RF
Robert G. Freeman
Oracle ACE
Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON IT'S
WAY SOON!
OCP: Oracle Database 11g Administrator Certified Professional Study
Guide (Sybex)
Oracle Database 11g New Features (Oracle Press)
Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Oracle9i RMAN Backup and Recovery (Oracle Press)
Oracle9i New Features (Oracle Press)
Other various titles out of print now...
Blog: http://robertgfreeman.blogspot.com
The LDS Church is looking for DBA's. You do have to be a Church member
in
good standing. A lot of kind people write me, concerned I may be
breaking
the law by saying you have to be a Church member. It's legal I promise!
:-)
http://pages.sssnet.com/messndal/church/parachurch.pdf
Please help Logica to respect the environment by not printing this email /
Pour contribuer comme Logica au respect de l'environnement, merci de ne pas
imprimer ce mail / Bitte drucken Sie diese Nachricht nicht aus und helfen Sie
so Logica dabei, die Umwelt zu schützen / Por favor ajude a Logica a respeitar
o ambiente nao imprimindo este correio electronico.
This e-mail and any attachment is for authorised use by the intended
recipient(s) only. It may contain proprietary material, confidential
information and/or be subject to legal privilege. It should not be copied,
disclosed to, retained or used by, any other party. If you are not an intended
recipient then please promptly delete this e-mail and any attachment and all
copies and inform the sender. Thank you.
Other related posts:
