Re: Read Only User

From: rjamya <rjamya_at_gmail.com>
Date: Sun, 19 Dec 2004 10:28:23 -0500
Message-ID: <9177895d0412190728906a7f9@mail.gmail.com>

We make two copies of production databases to developers every day. One is specifically meant for application support to debug issues, second one to let developers run their monthly release scripts. Our SA with our help wrote a perl script that takes source and dest database and takes care of _everything_.

This works far better than lettign developers into production databases. Of course the refreshes include scrambling sensitive data.

Raj

On Fri, 17 Dec 2004 08:03:43 -0800 (PST), Peter Barnett <regdba_at_yahoo.com> wrote:
> We have 'production support' databases which are
> essentially clones of production. Reloading is
> sometimes a pain but they are great for developer
> trouble shooting without letting them get their hands
> on production.
>

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

Received on Sun Dec 19 2004 - 09:23:44 CST