Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Managing developers recommendations

Re: Managing developers recommendations

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Wed, 12 Oct 2005 23:15:49 +0200
Message-ID: <032501c5cf72$207950d0$b800a8c0@IBME1D11967173>


We use the DEV-TEST-PRODUCTION schema. The developers can use any tool on DEV instances and test their code on TEST environment. They *don't* have access to PROD instances.

Usually works fine :O)

Cheers,
Dimitre Radoulov

> Toad w/ DBA module or who have access to generic schemas that contain
> important data == bad.
>
> Regular Toad with individual developer accounts, no insert/update/delete
> access on important tables, roles, role-level security and limits on the
> autoextend feature for specific tablespaces == good practice.
>
> my one big complaint about toad: by default it comes with "autocommit off"
> ... which is fine, but it means every session opened to a schema in the
> database has an implicit "begin transaction" attached to it, so you've
> got lots of uncommitted/open transactions ... which can block processes
> from time to time.
>
> Sounds like you've got a very unorganized dev environment going on ...
> your
> problem isn't the use of Toad, its the lack of a properly configured
> workspace for your programmers.
>
> todd
>
>>
>> Hi all,
>> My developers (who currently just use SQL Plus) now are wanting to use
>> Quest TOAD. From what I've used it in the past, it is far too powerful
>> for
>> developers. (I don't trust my developers with creating tablespaces,
>> etc.).
>> Plus, I've found that TOAD is far too easy to delete objects, etc.
>> Any recommendations, etc would greatly be appreciated!
>> -Fred S.
>>
>> _________________________________________________________________
>> Express yourself instantly with MSN Messenger! Download today - it's
>> FREE!
>> http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 12 2005 - 16:17:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US