Re: patterns for database administration - Mailing list pgsql-general

From Matthew Hixson
Subject Re: patterns for database administration
Date
Msg-id 1FB197FD-7CFE-11D8-B6BA-000A95D05926@poindextrose.org
Whole thread Raw
In response to Re: patterns for database administration  ("Chris Boget" <chris@wild.net>)
List pgsql-general
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@


pgsql-general by date:

Previous
From: Mike Nolan
Date:
Subject: Re: patterns for database administration
Next
From: Bill Moran
Date:
Subject: Re: patterns for database administration