Re: phisical MDF without security...
From: Andrew J. Kelly (firstname.lastname@example.org)
From: "Andrew J. Kelly" <email@example.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" <firstname.lastname@example.org> 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" <email@example.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" <firstname.lastname@example.org> 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 > > > > > > > > > > > >