Re: Oracle Administration...?
Date: Wed, 5 May 1993 01:18:37 GMT
Message-ID: <1993May5.011837.16691_at_sporty.col.oh.us>
David S. Masterson (davidm_at_consilium.com) wrote:
: 1. Do you allow your developers to create databases or reserve this capability
: to a select group (the DBAs)?
In our shop, DBA's create all databases. Beyond that, the developer can create, modify and delete tables, indexes, views, etc. The developer has total authority to alter a database that was created for him/her.
The DBMS folks are available for consultation when people want ideas for data modelling and how to set up effective databases.
: 2. How do you handle test databases? Do developers make a copy of the master
: database to populate for testing purposes?
The DBA creates a test database from the production database. They can copy the current contents or allow the developers/testers to populate the tables.
Jeff Anderson jeff_at_sporty.col.oh.us H: 614-252-7563 jeff_at_sporty.UUCP W: 614-249-0747 B7 f+ t w dc g+ k+ s+ r -------------------------------------------------------------------------------Received on Wed May 05 1993 - 03:18:37 CEST