Re: Ecrypting a database

From: krygim (krygim_at_hotmail.com)
Date: 11/07/03

  • Next message: John Kane: "Re: Permission of SP_FULLTEXT_TABLE in stored procedure" 
    Date: Fri, 7 Nov 2003 12:05:32 +0800

    May I know what "pgp" is?

    KM

    "Nick" <anonymous@discussions.microsoft.com> wrote in message
    news:030c01c3a4b2$8a529df0$a501280a@phx.gbl...
    > Um... What if the user/intruder takes the system offline
    > and boots into another OS and pulls the information? ACL's
    > arn't going to help there.
    > Windows comes with a native file/folder encryption, EFS.
    > EFS, does allow either the local administrator or the
    > domain admin default privilages, but you can remove this
    > even though it's not recommended. But, yes the service
    > account would need access to the database to unencrypt the
    > information. Or, you can use something like pgp.
    >
    > Nick
    > DCRM - Does Certifications Really Matter
    > >-----Original Message-----
    > >I am not sure why you want to encrypt the folder. You can
    > have proper ACL's
    > >to block the user from listing or viewing your database
    > files. And you can
    > >restrict using database roles security features by giving
    > access to your
    > >application only.
    > >
    > >--
    > >HTH,
    > >Vinod Kumar
    > >MCSE, DBA, MCAD, MCSD
    > >http://www.extremeexperts.com
    > >
    > >Books Online for SQL Server SP3 at
    > >http://www.microsoft.com/sql/techinfo/productdoc/2000/book
    > s.asp
    > >
    > >
    > >"krygim" <krygim@hotmail.com> wrote in message
    > >news:OzkwbK3oDHA.1072@TK2MSFTNGP09.phx.gbl...
    > >> I have a SQL database which will only be accessed only
    > by an application
    > >> (written by me). I want to put the database into a
    > Windows 2000 encrypted
    > >> folder so that even the network domain administrator
    > will not be able to
    > >> view the content (bypassing my application). Is this
    > viable? If so, which
    > >> Windows account do I need to log in to encrypt the
    > folder? Do I need to
    > >log
    > >> in as the SQL service account to do the encryption?
    > >>
    > >>
    > >>
    > >> TIA
    > >>
    > >>
    > >
    > >
    > >.
    > >

  • Next message: John Kane: "Re: Permission of SP_FULLTEXT_TABLE in stored procedure"

    Relevant Pages

    • Re: Folder encryption transparent to user
      ... It's not folder based per se as it ... creates a special encrypted virtual disk, but the disk can stay mounted as ... > Does anyone know of an encryption package that can encrypt a Win 2000 ... > In effect I want a combination of EFS and PGP. ...
      (comp.security.misc)
    • Re: Folder encryption transparent to user
      ... It's not folder based per se as it ... creates a special encrypted virtual disk, but the disk can stay mounted as ... > Does anyone know of an encryption package that can encrypt a Win 2000 ... > In effect I want a combination of EFS and PGP. ...
      (comp.security.misc)
    • Folder encryption transparent to user
      ... Does anyone know of an encryption package that can encrypt a Win 2000 folder ... The folder and all encrypted files should then be ... In effect I want a combination of EFS and PGP. ...
      (comp.security.misc)
    • Folder encryption transparent to user
      ... Does anyone know of an encryption package that can encrypt a Win 2000 folder ... The folder and all encrypted files should then be ... In effect I want a combination of EFS and PGP. ...
      (comp.security.misc)
    • Re: Encrpyting Microsoft Access databases
      ... The only encryption that Access can handle "natively", ... Perhaps the PGP folks meant that you could ... encrypt a database with PGP, send it to someone else, then the ...
      (microsoft.public.access.security)