Re: patterns for database administration

From: Matthew Hixson <hixson(at)poindextrose(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: patterns for database administration
Date: 2004-03-23 19:13:10
Message-ID: 1FB197FD-7CFE-11D8-B6BA-000A95D05926@poindextrose.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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@

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2004-03-23 19:16:34 Re: patterns for database administration
Previous Message Matthew Hixson 2004-03-23 19:11:41 Re: patterns for database administration