Re: How do you feel about allowing non-DBA's on your database servers?
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: Jeremy.Sheehan@xxxxxxx
- Date: Mon, 27 Jul 2009 10:44:27 -0500
The only people that should have access to the production servers are
systems admins and dba's. And some people dont want to let the DBA's on.
There is no way the general user should have access. I can see it now...
36 support guys trying figure out why the system is slowing down, each one
of them running top...
There are also serious SOX compliance issues, but if you are not publicly
held SOX does not apply. Had you considered running a single real time
display somewhere so they can see what is going on, but cant log on
individually?
On Mon, Jul 27, 2009 at 10:35 AM, SHEEHAN, JEREMY <Jeremy.Sheehan@xxxxxxx>wrote:
> Maybe if you had 3 sets of servers (PROD, TEST, DEV), it would be ok to
> let htem work on DEV, but PROD and TEST? No way. Everything should be as
> clean as possible and allowing more people onto the servers just mucks it
> all up.
>
>
>
> Jeremy
>
> P *Consider the environment. Please don't print this e-mail unless you
> really need to.*
>
>
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Robert Freeman
> *Sent:* 27 July, 2009 11:31 AM
> *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
>
>
>
>
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
