Re: patterns for database administration

On Mar 23, 2004, at 10:35 AM, Chris Boget wrote:

>>    Has anyone ever heard of using a separate administration database
>> which is used to modify business data, and then periodically that data
>> would be pushed out to the other database running the customer web
>> application?  Does this idea make any sense at all?
>
> You could give the administrators access to all of the tables and just 
> give
> the customer access to views only.  That would be one possibility, I 
> think.

This is an EJB application that is already up and running in the real 
world.  Refactoring it as you suggest is not an option for us at this 
time.
   -M@