Re:Data Encryption

From: Vishal Parkar (vgparkar@hotmail.com)
Date: 11/13/02 

From: "Vishal Parkar" <vgparkar@hotmail.com>
Date: Wed, 13 Nov 2002 01:01:39 -0800

SQL Server has 2 undocumented password encryption function
by which you can encrypt and decrypt a string.

Following is the example.

declare @x varbinary(500)
declare @ret int
select @x=convert(varbinary(500),pwdencrypt('check'))
select pwdcompare('check',@x, 0)

You can use pwdencrypt in a update/insert trigger to
encrypt the values of a table's column. While decrypting
you'll have to use pwdcompare which will return 0 or 1 on
the basis of failed or successfull comparison respectively.

for more information visit
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=9809

--Vishal

>-----Original Message-----
>Oracle 8i + includes the OBFUSCATION toolkit which
enables
>the creation of hash and random keys. Does anyone know if
>MSSQL 7/2k offers the same type of encryption for
>sensitive data?
>
>Note: my encryption has to be done through a store proc,
>not through any other software.
>
>Thanks, JB
>.
>

Relevant Pages

  • How do I Use DPAPI to Encrypt and Decrypt Data (C#/VB.NET)?
    ... Use DPAPI to Encrypt and Decrypt Data ... The code below demonstrates how to call Data Protection API (DPAPI) ... In addition to encryption and decryption, ... public static string Encrypt ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Byte array to string and back - newbie question
    ... // Create a symmetric algorithm. ... This is done to make encryption more ... // Encrypt a string into a string using a password ... // Decrypt a byte array into a byte array using a key and an IV ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: CryptAPI(encryption/decryption)
    ... It seems like you're missing the Base64 decode step when trying to decrypt ... I misspelled the Private Key as Primary Key. ... Is there any variation in the encryption format in openssl compared to ... "Dylan DSilva " wrote: ...
    (microsoft.public.pocketpc.developer)
  • Re: Writing spaghetti code for obfuscation/encryption
    ... > undocumented opcodes and simple encryption? ... do the protection and distribution (I'll justify this later, ... This key was used to decrypt the main program code. ... So here's the scheme in action: Put disk in, ...
    (comp.lang.asm.x86)
  • Re: Which is more secure RC2 or RC4 ?
    ... Credit card info... ... If your application can decrypt the information (in order to send it ... one goofy solution may be to use public key encryption on ... decryption key on a separate computer (laptop). ...
    (sci.crypt)