> > > Hi Experts
> > >
> > > I am facing problem of Data Base Security. Users at user end open table in browse window and change data manually and blaming me that my software automatically changes their data. No body is accepting the responsibility. Some of my friends are saying me to shift to SQL Data Base and leave VFP becase its data is unsecured. I am using Free Table. If I shift then is it my correct decesion. Is VFP have no solution at all for this kind of problems.
> > >
> > > Tnnx in advance
> > >
> > > Ahsan Rana
> >
> >
> > Hi,
> > VFP backend are unsecure .. end of story and end of debate.
> > You can try a variety of things, even encrypting, but what is to
> > say a user will open a table and enter over your encryption and
> > destroy your decryption.
> > I moved off to SQL-Server for all of the above reasons.
> > The only method I have found that provides secuity for VFP backends
> > is to place the VFP database and tables in a share that is not
> > seen on the network. You then in you application use the
> > SET DEFAULT TO UNC path and the logged in use has permissions
> > into this path. If the user cannot see the share and does not
> > know the path your VFP backend is secure.
> > Pete from the Great White North. (Only in Canada, ay.) Over and Out ...
>
> Hi Pete
>
> Given that the user may not want the additional overhead and COST of SQLServer, I think your solution makes the most sense for a VFP backend without going to Client Server. I don't believe that encrypting a field will solve anything, and what if you need to do a SELECT or INDEX on that field?
>
> Your solution is similar to Application Roles in SQLServer which is what we use. Even in SQLServer only our VFP application has access to the data.
>
> Could you please elaborate on your idea or maybe a FAQ?
>
> PS I did not rate your post but will when you post the FAQ, since not everyone can afford SQLServer :)
>
> Bernard
>
> ** If you see someone without a smile, give em one of yours :) **


Hi,
I am considering writing a BLOG on this a few other items.
Pete from the Great White North. (Only in Canada, ay.) Over and Out ...