Re: Privileges by session
- From: Martin Bach <development@xxxxxxxxxxxxxxxxx>
- To: nupendra@xxxxxxxxxxx
- Date: Sun, 10 Jan 2010 18:01:25 +0000
Dear list members!
This is a really interesting thread with lots of useful information, but
one important option (IMO) has not yet been mentioned.
If the main reason for allowing developers access to production data is
for them to troubleshoot problems using current data, why don't you use
your favourite replication mechanism such as streams or logical standby
to a separate environment? Developers could use this to their heart's
delight and you can impose your read only restrictions. There shouldn't
be a logical argument against getting them off production with that
approach either.
Any fixes can then be tested against the integration environment before
it's rolled out to production by the DBAs. You could even use a physical
standby to perform this testing: use flashback database or snapshot
standby to activate it and test against current data, then revert it
back to the standby role.
Hope this helps,
Martin
--
Martin Bach
OCM 10g
http://martincarstenbach.wordpress.com
On 09/01/10 00:00, Upendra N wrote:
> In our environment we have software dpkgs are built without the
[...]
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » Privileges by session- Blanchard, William
- » Re: Privileges by session- lyallbarbour
- » RE: Privileges by session- Blanchard, William
- » RE: Privileges by session- Jackie Brock
- » RE: Privileges by session- Blanchard, William
- » RE: Privileges by session- Christopher Boyle
- » RE: Privileges by session- Blanchard, William
- » RE: Privileges by session- Blanchard, William
- » RE: Privileges by session- Blanchard, William
- » RE: Privileges by session- Jackie Brock
- » Re: Privileges by session- Kellyn Pedersen
- » RE: Privileges by session- Blanchard, William
- » RE: Privileges by session- Blanchard, William
- » Re: Privileges by session- Jared Still
- » RE: Privileges by session- Blanchard, William
- » Re: Privileges by session- Michael Fontana
- » RE: Privileges by session- Blanchard, William
- » Re: Privileges by session- Jared Still
- » RE: Privileges by session- Blanchard, William
- » Re: Privileges by session- Andre van Winssen
- » RE: Privileges by session- Barun, Vlado
- » Re: Privileges by session- Jared Still
- » Re: Privileges by session- Robert Freeman
- » RE: Privileges by session- Andre van Winssen
- » Re: Privileges by session- Joan Hsieh
- » Re: Privileges by session- Thomas A. La Porte
- » Re: Privileges by session- Michael Fontana
- » Re: Privileges by session- Martin Berger
- » RE: Privileges by session- Upendra N
- » Re: Privileges by session - Martin Bach
- » Re: Privileges by session- Pete Finnigan
- » Re: Privileges by session- Peter Hitchman
- » RE: Privileges by session- Joel.Patterson
- » RE: Privileges by session- Barun, Vlado
- » Re: Privileges by session- Kellyn Pedersen
- » RE: Privileges by session- GovindanK
- » Re: Privileges by session- Pete Finnigan
- » Re: Privileges by session- Yechiel Adar
- » Re: Privileges by session- Jared Still
- » Re: Privileges by session- Yechiel Adar