Re: Database protection

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

Date: Thu, 15 Sep 2005 03:03:18 -0500

Thanks Uri

But if the user is logged on to Windows as an Administrator, doesn't this
user also has Admin right to the database by default? If this is the case,
even if I create a new database user it won't help because the person logged
into Windows as an administrator can automatically logging as "SA". Is this
the right?

"Uri Dimant" <urid@iscar.co.il> wrote in message
news:eCCe1OcuFHA.3452@TK2MSFTNGP14.phx.gbl...
> 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

  • Re: Error trying to connect to Access Database
    ... windows admin userid and password. ... your database isn't updatable because of the permissions issue. ... Are you the administrator of the server where the ASP is running? ... I do not know what else to do, and I am trying to get a web site done. ...
    (microsoft.public.access.gettingstarted)
  • SourceForge.net Sitewide Update: Jan 26th, 2005 (fwd)
    ... I just returned from an enjoyable Open Source conference in Hawaii ... open sourced the database under the name Derby. ... The CVS client SF.net staff recommend for MS Windows users is ... priority technical support. ...
    (comp.os.linux.announce)
  • Re: SQL Server Express
    ... These are true if the Windows user is an administrator for any database - ... GRANT CREATE DATABASE on DATABASE::xxx to SAM ... figured out the SCHEMA topics in SQL Server 2005). ...
    (microsoft.public.sqlserver.msde)
  • Re: Is this possible??
    ... I understand Windows security but since I've not seen A2007 live, ... The backend is on the server in it's own file. ... database, but everyone does not need to have access to tblwage which is ...
    (microsoft.public.access.tablesdbdesign)
  • Re: How many companies are buying new AS400s
    ... Just like you do in iSeries navigator. ... SAVEPOINTs and ROLLBACKs are easy in any database that supports them, but what about analysis of the actual individual entries? ... Is it as easy to do this in Windows or Linux? ... I know how OS/400 work management lets me tune it so the customer is happy during those three or four minutes and is just as happy during the remaining 23:56 of the day. ...
    (comp.sys.ibm.as400.misc)