Re: 2 Keys decrypts same message

From: Simon Johnson (Ckwop_at_hotmail.com)
Date: 07/08/03 

Date: 8 Jul 2003 08:42:06 -0700

> My problem is the following, I have a database
> that needs to be encrypted.
> Some of the rows need to be accessed (decrypted)
> by one person and other by another person, etc.
> I'm talking about 1 million rows and 200 users.
>
> My idea is to encrypt using a password for each user,
> but in the case (very probable) that the user
> forgots the password I need to be able to decrypt
> the data encrypted with his/her password.
>
> I don't want to encrypt each row twice (with a admin password
> and user password) because it will be twice the space.
>
> I don't want to use a *master* key to encrypt every
> row, and encrypt this master key with each user password,
> because user passwords can be weak and compromise all the
> data (not only the user one).
>
> That's why I wanted to decrypt the same data with two
> different keys.
>
> As suggested, I might generate a random Key for each set
> of rows and encrypt the key with the admin password and
> the user password. Then use that key for the set of rows.
>
> anyone has a better idea ??
>
> thanks!
>
> Jorge
>

RSA would do it though it'd be slow. use m^e mod n as a hash and use
the exponent d to decrpyt the password.

Relevant Pages

  • Re: 2 Keys decrypts same message
    ... I don't want to encrypt each row twice (with a admin password ... and user password) because it will be twice the space. ... That's why I wanted to decrypt the same data with two ... Jorge ...
    (sci.crypt)
  • Re: 2 Keys decrypts same message
    ... > I don't want to encrypt each row twice (with a admin password ... > and user password) because it will be twice the space. ... > That's why I wanted to decrypt the same data with two ... encrypt the cipher AND that password with the master key? ...
    (sci.crypt)
  • Re: Get user password in Active Directory
    ... get encrypted user password from Active Directory, ... to compare it with the database value. ... do you know any way to encrypt an user password with the ...
    (microsoft.public.windows.server.active_directory)
  • Re: Get user password in Active Directory
    ... get encrypted user password from Active Directory, ... to compare it with the database value. ... do you know any way to encrypt an user password with the ...
    (microsoft.public.windows.server.active_directory)
  • Re: Cracking a PDF Password?
    ... Encrypt a custom PDF and decrypt it back to original. ... pdftk is Adobe-friendly and requires the owner password (user password won't work) due to PDF requirements, but the user password would suffice as well. ... if AR can do it (decrypt with the user password) any program can. ...
    (comp.text.pdf)