Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Schema updates - roles

RE: Schema updates - roles

From: Kerber, Andrew W. <>
Date: Thu, 29 Mar 2007 07:22:06 -0500
Message-ID: <>

The simplest reason is that you don't want to give developers the necessary privileges to create objects outside of their personal schemas, and developers typically don't have personal schemas in production. The other answer is that in most places, the Unix admins and the Wintel admins are the people who put the changes in, not developers.  

-----Original Message-----
[] On Behalf Of Brady, Mark Sent: Wednesday, March 28, 2007 1:24 PM
Subject: RE: Schema updates - roles  

I've never understood why this is so:  

Our Unix Admins don't execute our changes to our Unix apps

Our Wintel Admins don't execute our changes to our Wintel apps

Our Database Admins insist they execute our changes to our database apps.    

Please no knee-jerk reactions. Everyone thinks/feels their area is special, that no one could live without them. Before you answer with "database servers are special because _____________" think twice.  

If developers promote code to production web servers, production app servers, production Unix servers, why not production database servers?    

[] On Behalf Of Dennis Williams Sent: Wednesday, March 28, 2007 10:36 AM To:
Subject: Re: Schema updates - roles  

    One final argument for separating duties. Today your developers may indeed be top-notch. However, tomorrow a big project may be started and many contractors hired to develop on the new project. If you have a history of developers updating production, it may be difficult to clamp down on some cowboy developer before they trash your production.    

>>> This e-mail and any attachments are confidential, may contain legal,
professional or other privileged information, and are intended solely for the
addressee. If you are not the intended recipient, do not use the information
in this e-mail in any way, delete this e-mail and notify the sender. CEG-IP2

NOTICE: This electronic mail message and any attached files are confidential. The information is exclusively for the use of the individual or entity intended as the recipient. If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited. If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.
Received on Thu Mar 29 2007 - 07:22:06 CDT

Original text of this message