RE: Secure Database Design Part II

2003-08-18 Thread Rob A. Brahier
] Subject: RE: Secure Database Design Part II Hi Firstly if your application is well designed then your data should not be accessible by the wrong users - if you make sure that there is no way the wrong supplier id can be allocated - put an extra 'are you sure this is correct' check, make it so

RE: Secure Database Design Part II

2003-08-16 Thread Peter Lovatt
the users to see some history then don't display the detail - no prices or part ids - whatever you can get away with. HTH Peter -Original Message- From: Nils Valentin [mailto:[EMAIL PROTECTED] Sent: 16 August 2003 05:05 To: Lefevre, Steven; [EMAIL PROTECTED] Subject: Re: Secure Database

Re: Secure Database Design Part II

2003-08-15 Thread Nils Valentin
Hi Steven, I believe I understand your concerns. I think the only way to reduce the risk of associating the wrong data is tripple checking it by different persons or even better make two tables which you can compare against each other. The second table only readable to you. This way you could