Re: Encryption at field level

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 06/10/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Mon, 10 Jun 2002 06:22:45 -0600

Nothing built in. You can write your own using the Crypto
API or some other encryption libraries. There is a link to
a sample xp that does encryption and some additional
information on encryption alternatives in this FAQ:
http://www.mssqlserver.com/faq/general-encrypt.asp

You can also find some third party links in the Encryption
entry at SQLSecurity.com:
http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=1&tabid=2

-Sue

On Mon, 10 Jun 2002 03:56:44 -0700, "Bryn"
<jonesb@cheshire.gov.uk> wrote:

>Is it possible to encrypt a field (or all the fields) of a
>table so that a sysadmin is unable to read the data (using
>for example Ent Mgr or Query Analyzer) & is also unable to
>grant him/herself access to do so ?
>
>If so how does one go about it ?
>
>TIA
>Bryn

Relevant Pages

  • Authenticated encryption with PyCrypto
    ... I looked at ezPyCrypto, but it seemed to require public and private ... encryption is trivial to do with ezPyCrypto as well? ... the documentation, ... to have a simple API for an industry-strength encryption module? ...
    (comp.lang.python)
  • Re: Passwords, computer ID
    ... AD does not provide any facility to access the password data programmatically, even if reversible encryption is used. ... There is also no documentation about this particular feature works or can be accessed by applicationss that need the plaintext password. ... A client will contact the server and ask for an account password ... similar API requiring a password ...
    (microsoft.public.windows.server.security)
  • Re: Securing data to a process identity
    ... CryptProtectData is good for the actual encryption - but Steve's issue is how ... You MAY think that instead of a filter driver you can simply hook ... encryption API to encrypt data based on something unique to the security ... An obvious secret associated with the process' identity is the password ...
    (microsoft.public.platformsdk.security)
  • Re: How do I send an s/mime e-mail using x509v3?
    ... thrilled with their API as it doesn't really integrate with the Framework at ... a lookup to AD and some crypto API calls to determine which cert is the ... encryption cert and which one is the signing cert since the .NET ... I've searched google and found an s/mime tool made by Chilkat ...
    (microsoft.public.dotnet.security)
  • Securing data to a process identity
    ... encryption API to encrypt data based on something unique to the security ... so that I get the same challenge response packet ... to get the actual reversible encryption key. ...
    (microsoft.public.security)