Re:RE: Oracle DBA evolution path - please share your opinion

From: <dgoulet_at_vicr.com>
Date: Thu, 15 Mar 2001 13:11:59 -0800
Message-ID: <F001.002CE207.20010315125030@fatcity.com>

HUMMM, It looks to me like you've given the keys to the kingdom to the developers, namely the system account. Well, I don't know about you folks, but over here no one, and I mean NO ONE outside of the DBA crew has the passwords for sys, system or the Oracle unix account. Basically if any of the developers wants something done at the Unix level, like deleting a datafile, or the Oracle system level like starting or shutting down the DB, they come to us, PERIOD.

Now I can understand why some folks get so stressed out. Our developers have a schema or two that they can trash around in all they want in development. Outside of that the DB belongs to me.

Dick Goulet

"Walk softly, but carry a BIG stick."

____________________Reply Separator____________________
Author: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date:       3/15/2001 11:50 AM

> -----Original Message-----
> From: Rachel Carmichael [mailto:carmichr_at_hotmail.com]
> Sent: jeudi, 15. mars 2001 06:43
> 
> nice, very nice..... and just in time, as I have decided to 
> "put a stake in 
> the ground" (to quote our CTO) and take back control of my 
> databases. My 
> programmers have been allowed to run riot due to a limited 
> number of hours 
> in the day for me to get things done. No more.

>
> Now, where did I leave that kevlar vest?

I know the feeling. I've been trying to "organize" our development databases here and encourage some of our QA people / developpers to not install the products in the system tablespace. Also I have mentioned a few times since I've been here that if you want to delete a datafile from the disk, it's best to drop the tablespace from the database first! Of course when the database won't start up they turn to me.

This week I'm going through all our databases and changing the sys and system passwords to something else, and creating developper accounts that don't have DBA privilege. When I send out the e-mail outlining my little plan I think I'll have to hire some button men and hit the mattresses. For the next few days I'll be hiding in the bunker. It's probably best if I perform my DBA duties whilst peering out through that little slit.

Jacques Kilchoer - master of the Mafia metaphore
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2652.35">
<TITLE>RE: Oracle DBA evolution path - please share your opinion</TITLE>
</HEAD>
<BODY>

> -----Original Message-----
 > From: Rachel Carmichael [<A
HREF="mailto:carmichr_at_hotmail.com">mailto:carmichr_at_hotmail.com</A>]
 > Sent: jeudi, 15. mars 2001 06:43
 > 
 > nice, very nice..... and just in time, as I have decided
to 
 > "put a stake in 
 > the ground" (to quote our CTO) and take back control
of my 
 > databases. My 
 > programmers have been allowed to run riot due to a limited

 > number of hours 
 > in the day for me to get things done. No more.
 > 
 > Now, where did I leave that kevlar vest?

 

I know the feeling. I've been trying to "organize" our
development databases here and encourage some of our QA people / developpers to not install the products in the system tablespace. Also I have mentioned a few times since I've been here that if you want to delete a datafile from the disk, it's best to drop the tablespace from the database first! Of course when the database won't start up they turn to me.

This week I'm going through all our databases and changing the
sys and system passwords to something else, and creating developper accounts that don't have DBA privilege. When I send out the e-mail outlining my little plan I think I'll have to hire some button men and hit the mattresses.

For the next few days I'll be hiding in the bunker. It's
probably best if I perform my DBA duties whilst peering out through that little slit.

Jacques Kilchoer - master of the Mafia metaphore


</BODY>
</HTML>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Mar 15 2001 - 15:11:59 CST