Re: Database protection

From: Uri Dimant (urid_at_iscar.co.il)
Date: 09/15/05 

Date: Thu, 15 Sep 2005 10:04:23 +0300

Rene
Create a new Login (DD) in SQL Server and and don't CRANT permission it to
the database. Now, when the user login with as DD he/she will not be able
access to the database

"Rene" <nospam@nospam.com> wrote in message
news:uwzGIpbuFHA.2072@TK2MSFTNGP14.phx.gbl...
> 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