Create a cache DB between web portal and internal DB? - Mailing list pgsql-general

From Dearman, Rick
Subject Create a cache DB between web portal and internal DB?
Date
Msg-id 5E2CA264644A9B44B12E6B08AA50B0F36FF890@teusv-msgtab01.uk.core.dir.telstra.com
Whole thread Raw
Responses Re: Create a cache DB between web portal and internal DB?  (Dick Davies <rasputnik@hellooperator.net>)
Re: Create a cache DB between web portal and internal DB?  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
I have a requirement from my security manager but I can't seem to find a good solution. So I wondered if someone had
donesomething similar. 

We have a web portal and a DB in PostgreSQL (obviously) which contains user data. The portal is accessed by account
managerswho have access to only specific user accounts. This all works fine however the concern is that if you ever got
accessmore directly into the DB through a hack, or poorly designed site code, you could potentially access information
thatyou shouldn't.  

So the idea is that he is floating is we create a cache DB between the portal and the main DB which will only keep the
informationcurrently being worked on by the person logged in, and that any inserts/updates/deletes are passed on to the
mainDB through additional layers of security. 

Any ideas?

Rick Dearman





-----------------------------------------------------------------------
The information in this email is confidential and may be legally
privileged. It is intended solely for the addressee(s). Access to this
email by anyone else is unauthorised. If you are not the intended
recipient, please delete this e-mail and notify Telstra. Any disclosure
of the contents or recipients, distribution of, copying of or decisions
based on this email by unauthorised persons is prohibited and may be
unlawful.

Telstra Europe Ltd
3 Finsbury Square
London EC2A 1AE

pgsql-general by date:

Previous
From: Marcelo Cid
Date:
Subject: RES: NewsForge Poll: Favorite open source database?
Next
From: Marcelo Cid
Date:
Subject: RES: RES: NewsForge Poll: Favorite open source database ?