> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
> 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.
Well, I've only been here a couple of months so I don't want to make a lot of enemies (yet). To be fair all the developpers in my group are very knowledgeable. Several of them know details about Oracle internals that even I didn't know (for example some of my colleagues are the people that wrote Shareplex.) Most of these databases were originally created by the developers and all of them still had the default passwords for sys and system. Since we're a software shop and support many version of Oracle there is a large number of development databases on many platforms, and most of the developpers have also created Oracle dbs on their individual Windows machines. So they are used to the laissez-faire attitude. But if I'm in charge of making sure the databases are always available and that test environments can be recreated rapidly, I'll have to tell them that we need to be a little more careful.
So there will be some changes now that I'm here, MWAHAHAHAHA! I'm thinking of having a big sign printed up that says "All your databases are belong to us."
------
any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer.
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com
