msde security...........................

I have a business directory software done in vb.net and sqlserver .We are
using msde for distribution purpose .The problem we are facing is about the
security of the data . The cd goes to common man and we are concerned about
the security of the data.Is there any option where we can ensure that the
database cannot be opened by the user . please help
..Urgent.........................
If by "common man" you mean that the database is installed on each
person's computer in their own MSDE instance, then the answer is no,
you can't prevent them from getting at the data because they are a
system administrator on that instance. If the database is located on a
server, then it is possible to implement a more robust security scheme
since users can be prevented from accessing the physical files and
from connecting as system administrators.
--Mary
On Thu, 8 Sep 2005 13:33:01 -0700, "techiebose"
<techiebose@.discussions.microsoft.com> wrote:

>I have a business directory software done in vb.net and sqlserver .We are
>using msde for distribution purpose .The problem we are facing is about the
>security of the data . The cd goes to common man and we are concerned about
>the security of the data.Is there any option where we can ensure that the
>database cannot be opened by the user . please help
>.Urgent.........................
sql