RE: New Survey

        There are a number of problems that you can have with developers having backdoor access, other than read only, that are regulatory in nature, other wise known as "cooking the books". This inherently is a problem because many applications don't audit system access outside of the application. They can also create a pile of problems with applications by locking objects, rows, or other items that you normally would not see. I remember a developer who somehow had production access & was trying to replace a package in the production DB, thinking he was on dev. It locked up the application for a good 10 minutes and then caused a pile of errors, corrupted data, etc..., that lead up to a 6 hour down time. OOPS didn't even come close.

Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International

-----Original Message-----

From: Blanchard, William [mailto:wblanchard_at_societyinsurance.com] Sent: Wednesday, December 16, 2009 2:04 PM To: Goulet, Richard; oracle-l_at_freelists.org Subject: RE: New Survey

I would be happy just being able to lock them out of production (read-only access). I'm trying to run uphill into a 100mph headwind.

WGB  
-----Original Message-----

From: Goulet, Richard [mailto:Richard.Goulet_at_parexel.com] Sent: Wednesday, December 16, 2009 12:49 PM To: Blanchard, William; oracle-l_at_freelists.org Subject: RE: New Survey

William,

        I have no problem with developers having READ ONLY access to production, staging, and QA. It gives them an ability to research problems with the app without always having to bother me. Beyond that no I do not approve of developers having access to anything other than DEV & I like to throw them all out on a monthly basis so that I can "rake out the sandbox".

Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Blanchard, William Sent: Wednesday, December 16, 2009 11:58 AM To: oracle-l_at_freelists.org
Subject: New Survey

Greetings listers,

I am trying to justify locking the developers out of our production database but I need your help. We just moved to a new landscape because the developers had horked up the last one so bad (production/qa/dev were completely out of sync). Please take a minute or two to visit SurveyMonkey and answer the survey I created.

http://www.surveymonkey.com/s/LQW738K

Thank you,

WGB
--

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

-

This email and any information, files, or materials transmitted with it are confidential and are solely for the use of the intended recipient. If you have received this email in error, please delete it and notify the sender.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Dec 16 2009 - 13:10:55 CST