RE: How do you feel about allowing non-DBA's on your database servers?

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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.

--
http://www.freelists.org/webpage/oracle-l