Re: phisical MDF without security...

From: Andrew J. Kelly (ajkellynospam@attbi.com)
Date: 03/10/03

  • Next message: Hal Berenson: "Re: phisical MDF without security..."
    From: "Andrew J. Kelly" <ajkellynospam@attbi.com>
    Date: Sun, 9 Mar 2003 18:52:58 -0500
    
    

    There is no way to password protect the file. If you don't want someone to
    access the file then don't give them access to the server.

    -- 
    Andrew J. Kelly
    SQL Server MVP
    "Tark Siala" <tarksiala@hotmail.com> wrote in message
    news:uTrGDRp5CHA.972@TK2MSFTNGP12.phx.gbl...
    > thank's
    > but you mean MDF File not have any internal security like MDB File ???
    > i think must have a password to allow access or not access to this file
    >
    > in this way i can access any MDF file aound the world
    > just attach file to my SQL
    > what u think ?
    > ________________________________
    > Best Regards From Tark
    > "Hal Berenson" <haroldb@truemountainconsulting.com> wrote in message
    > news:eLFujng5CHA.2424@TK2MSFTNGP09.phx.gbl...
    > > You need to use the operating system security mechanisms to prevent your
    > > friend from having access to the file.  If they are allowed to make a
    > > physical copy of the file then they can access the data.
    > >
    > > Also, if you have one of the versions of Windows that supports the
    > Encrypted
    > > File System (EFS) then you can use that to encrypt your entire database.
    > >
    > > Finally, please don't cross-post.
    > >
    > > --
    > > Hal Berenson
    > > True Mountain Consulting
    > >
    > >
    > > "Tark Siala" <tarksiala@hotmail.com> wrote in message
    > > news:#mh2ugd5CHA.3008@TK2MSFTNGP11.phx.gbl...
    > > > hi
    > > > i have SQL Server 2000 on my PC , and i manage Login and User
    > > > to set my Database under security.
    > > >
    > > > but my frnd copy my DB (MDF File i think where SQL Store all tables
    and
    > > > Login) to her PC
    > > > then connect it to instance SQL Server , and my frnd can see all my
    Data
    > > :(
    > > >
    > > > how i can secure my MDF file ??????????
    > > > and how can any ony login MDF file without i Added to Users and Logins
    > ???
    > > > is it a bug or i'm not do something ??
    > > >
    > > > please tel me
    > > > ________________________________
    > > > Best Regards From Tark
    > > >
    > > >
    > >
    > >
    >
    >
    

  • Next message: Hal Berenson: "Re: phisical MDF without security..."