Hi,

I use full database encryption (AES256) method to create a new Encrypted database for our project. Testing team want to verify the Database is encrypted or not.

How to validate whether the database is encrypted or not?

Thanks, Jeyan

asked 22 Feb '19, 02:18

Jeyan's gravatar image

Jeyan
26114
accept rate: 0%


If you try to start an encrypted database without an encryption key you get an error. I guess that is quite a good validation...

Could not connect to the database.

Incorrect or missing encryption key
[Sybase][ODBC Driver][SQL Anywhere]Incorrect or missing encryption key
SQLCODE=-840
SQLSTATE=08001
permanent link

answered 22 Feb '19, 02:42

Christian%20Hamers's gravatar image

Christian Ha...
677131632
accept rate: 42%

1

You could also try to open the database file in a (hex) editor and try to "grab some readable contents". Of course that would usually also fail even if the database is just obfuscated via "simple encryption"...

(22 Feb '19, 03:27) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×46

question asked: 22 Feb '19, 02:18

question was seen: 1,528 times

last updated: 22 Feb '19, 03:27