Database protection

From: Rene (nospam_at_nospam.com)
Date: 09/15/05 

Date: Thu, 15 Sep 2005 00:58:53 -0500

Is there a way to prevent users from logging into an MSDE database instance?
I created an MSDE instance using a strong SA password but I was still able
to logging to the database using Windows Authentication.

The reason I don't want the user to see the database is because the database
structure that I am distributing (MSDE) is exactly the same as the one I
have online. If I let the user peek into my MSDE database they might find a
way to mess-up the database that is online. I just don't want to take the
risk.

Also, is stored procedure encryption easily bypassed if I logon as a
database administrator?

Thanks.

Relevant Pages