ENCRYPTION/DECRYPTION - SQLSERVER 2005

Question

Post reply

ENCRYPTION/DECRYPTION - SQLSERVER 2005

hbk_sql

SSC-Addicted

Points: 425
More actions
April 15, 2011 at 8:44 am

#249046

In our database user table columns are encrypted.
HOw to find what kind of encryption is applied on database/table?
How to decrypt and query the data? appriciate your help. we are using sql server 2005 version
table name USER
USERID
USERFNAME
USERLNAME
USERADDRESS
USERPHNUM
USERZIPCODE
USEREMAILID
STATUSID

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

parthi-1705 SSCrazy Eights Points: 9277 More actions · Answer 1

How did you find that columns where Encrypted ?

Thanks
Parthi

hbk_sql SSC-Addicted Points: 425 More actions · Answer 2

hbk_sql

SSC-Addicted

Points: 425

April 15, 2011 at 8:59 am

#1312196

select * from user

I could see encrypted data

parthi-1705 SSCrazy Eights Points: 9277 More actions · Answer 3

hbk_sql (4/15/2011)
select * from user
I could see encrypted data

Im..In that which column where encrypted (all the columns or only few).

How was the encrypted data any sample you can have over here.

Thanks
Parthi

hbk_sql SSC-Addicted Points: 425 More actions · Answer 4

only few columns are encrypted.

for example user first name

4mul4unnK6D0q4FvMPEbnatLQH5gsaSrc9J4+mV63Xc=

user last name

rJFtI92/RJg3/ymvWG9qYL8+dLAAoGFsRA0cX1ArRFA=

Lowell SSC Guru Points: 323518 More actions · Answer 5

this is just a guess, but AES encryption would match that format, since it can be stored in a varchar instead of varbinary field...but how does that help at all? you need the key to decrypt it anyway.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

sturner SSC-Insane Points: 22411 More actions · Answer 6

All encryption is binary. It appears that particular encrypted data is encoded using BASE64 encoding which can be stored in a varchar() column.

I'm surprised you don;t have resources in your organization (who wrote the application?) that can give you the necessary details as to how to decrypt the data. It makes me suspicious that you would be asking for that information here on this forum.

In any case, short of brute force cracking with lots of time and CPU horsepower you will never decrypt that data if you don't have the keys, seed or the specific algorithm.

The probability of survival is inversely proportional to the angle of arrival.

hbk_sql SSC-Addicted Points: 425 More actions · Answer 7

I have joined recently here as a DBA and new to encryption. The previous only DBA left the organization I got keys to decrypt. Just want to know how to decrypt the data?

hbk_sql SSC-Addicted Points: 425 More actions · Answer 8

I just want to know if few columns are encrypted, script to query the data

table name USER

USERID

USERFNAME

USERLNAME

USERADDRESS

USERPHNUM

USERZIPCODE

USEREMAILID

STATUSID

jonathan.boado Grasshopper Points: 16 More actions · Answer 9

You should ask the developer what algorithm did he used in encrypting the data. It will require the Key, Type of Encryption, etc or some might also require the Salt key.