Help on Data Security choice ?

4 Mar 2005 12:49 PM

serge calderara

Dear all,

I need to make a strategic decision on an application where data security is
important. Collected data must be stored in a database and I need to create
an
application using vb.NET to collect those data and store them in that
database.

The problem is that data in that database is the know how of my company so
they need to be protected from not beeing copied, duplicated, exported..

First I was thinking to store the data in an access database located on a
file server with NTFS permision. But then anyone can copie the file to
another place even with a readonly attribute right ?

Then I was thinking of an SQL database, where it is a little bit harder to
copy database localy and you have to pass the server security and the
database security.

Depending of that choice, will I ahve to go to Windows APP or Web App to
keep in my this security point ?

What is the proper choice ?

thnaks for your help
Regards
Serge

5 Mar 2005 2:34 AM

Richard Welch

Serge,
If you try to copy a SQL .DBF and .LDF while the file is in use you will
get an error, the file would be in use by your SLQ server. As long as your
server is up and running you can not copy the SQL files. Assuming you only
let someone with admistrative rights start and stop the SQL service, your
data is quite secure.
Rick
Show quoteHide quote

"serge calderara" <sergecalder***@discussions.microsoft.com> wrote in
message news:135A9FD5-227B-4A87-ACB8-D1152D7860CA@microsoft.com...
> Dear all,
>
> I need to make a strategic decision on an application where data security
is
> important. Collected data must be stored in a database and I need to
create
> an
> application using vb.NET to collect those data and store them in that
> database.
>
> The problem is that data in that database is the know how of my company so
> they need to be protected from not beeing copied, duplicated, exported..
>
> First I was thinking to store the data in an access database located on a
> file server with NTFS permision. But then anyone can copie the file to
> another place even with a readonly attribute right ?
>
> Then I was thinking of an SQL database, where it is a little bit harder to
> copy database localy and you have to pass the server security and the
> database security.
>
> Depending of that choice, will I ahve to go to Windows APP or Web App to
> keep in my this security point ?
>
> What is the proper choice ?
>
> thnaks for your help
> Regards
> Serge
>