Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Developer access in test database
Jeff,
I agree with Raj. Further to what I said before, I have four database - dev, user test, training and production. Training and Prod are always at the same application release level. Developers have total access in dev; and query-only access in the rest.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Friday, April 12, 2002 9:13 AM
To: Multiple recipients of list ORACLE-L
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
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: Mercadante, Thomas F INET: NDATFM_at_labor.state.ny.us 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-LReceived on Fri Apr 12 2002 - 08:33:26 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |