• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Any Gurus in encryption?

New Here ,
Apr 04, 2006 Apr 04, 2006

Copy link to clipboard

Copied

Any gurus out there?
CFMX 6, Oracle9i

Does anyone know how I can easily search an encrypted column?

I have a whole bunch of sensitive material (text/html) stored as encrypted data but I can't see any easy way of searching that data for a keyword without openeing every record, decrypting the column, then searching it before moving on to the next record.
Is there an easy way to do this if at all?

Thanks for any help
TOPICS
Advanced techniques

Views

535

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Apr 04, 2006 Apr 04, 2006

Copy link to clipboard

Copied

> Is there an easy way to do this if at all?

The whole IDEA of encryption is to make it "difficult" to extract
information out of it without decrypting it.

So - almost by definition - no.

--
Adam

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Apr 06, 2006 Apr 06, 2006

Copy link to clipboard

Copied

Hi Adam
Thanks for your response
Do you know if there's an easy way of determining if data is encrypted once retrieved from the DB?
Like isNumeric(value) but for encrypted data:
e.g. isEncrypted(value)

?

Thanks
Jam

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Apr 06, 2006 Apr 06, 2006

Copy link to clipboard

Copied

Not really. There are stacks of different encryption schemes, and
obviously the encrypted results all look different from scheme to scheme.

--
Adam

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Mentor ,
Apr 06, 2006 Apr 06, 2006

Copy link to clipboard

Copied

How was your data encrypted? I found quite a lot of information regarding Data Encryption Using DBMS_OBFUSCATION_TOOLKIT in Oracle9i Application Developer's Guide - Fundamentals Release 2 (9.2) (Part Number A96590-01) documentation, which can be downloaded from Oracle.

Phil

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Apr 07, 2006 Apr 07, 2006

Copy link to clipboard

Copied

Phil - Data was encrypted using a private key and coldfusion Encrypt(string,key)

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
May 22, 2006 May 22, 2006

Copy link to clipboard

Copied

LATEST
Adam
FYI - It is indeed possible to search an encrypted column from a CF page. I have built a function to do this and it works very well!
Now I will answer all other similar posts (if you need the answer)

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation