Re: [GENERAL] Create a cache DB between web portal and internal DB?

2004-12-21 Thread Dick Davies
* Dearman, Rick [EMAIL PROTECTED] [1245 05:45]: I have a requirement from my security manager but I can't seem to find a good solution. So I wondered if someone had done something similar. We have a web portal and a DB in PostgreSQL (obviously) which contains user data. The portal is

Re: [GENERAL] Create a cache DB between web portal and internal DB?

2004-12-21 Thread Bruno Wolff III
On Mon, Dec 20, 2004 at 17:21:02 -, Dearman, Rick [EMAIL PROTECTED] wrote: I have a requirement from my security manager but I can't seem to find a good solution. So I wondered if someone had done something similar. We have a web portal and a DB in PostgreSQL (obviously) which contains

Re: [GENERAL] Create a cache DB between web portal and internal DB?

2004-12-21 Thread Frank D. Engel, Jr.
A much better way to do this, assuming that the database login uses the actual username/password of the manager in question (if not, see if this can be arranged securely): Assume you have a table with the restricted information. Call it real_data: CREATE TABLE real_data ( accountID

[GENERAL] Create a cache DB between web portal and internal DB?

2004-12-20 Thread Dearman, Rick
I have a requirement from my security manager but I can't seem to find a good solution. So I wondered if someone had done something similar. We have a web portal and a DB in PostgreSQL (obviously) which contains user data. The portal is accessed by account managers who have access to only