Oracle-L: RE: Developer access in test database

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Fri, 12 Apr 2002 05:13:20 -0800
Message-ID: <F001.004430B2.20020412051320@fatcity.com>

Jeff,

We have dba privileges granted to schema owners in devl databases, test database mimics the prod, so they just have appropriate roles. In prod, no schema level access, everyone goes in with their own id, and no one has those ANY privileges.

In next couple of months, we are cutting off developer access to prod. For fixing bugs and debugging, we create a database (named DAYOLD) that is same as production database at 5am that day. It's is all automatic, works fine and all developers are getting adjusted to the fact that prod access is going away.

Also we have a benefit of this dayold database, we can run and test all weekly releases on the dayold database, the day before they are applied to production, so we can catch all errors and get them fixed by developers before the code release, this is imp because when we do the code release, most of the developers are probably still in bed that early in the am.

Raj

Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----
Sent: Friday, April 12, 2002 8:38 AM
To: Multiple recipients of list ORACLE-L

In our test databases, I have always granted select,insert,update,delete any table to the developers.

While yesterday, one updated a "sys" table.

Be non-production, I always felt if it is destroyed can always be recreated.

What table privileges do you grant in "test".

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.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).



text/plain attachment: ESPN_Disclaimer.txt

Received on Fri Apr 12 2002 - 08:13:20 CDT