How to verify that a tables data on disk is encrypted. Of course using dbisql and unload expose clear data. Even using a bare bones ODBC client can connect as show data.

How to demo that the data is encrypted?

asked 13 Mar, 16:03

appdev's gravatar image

appdev
618
accept rate: 0%


permanent link

answered 13 Mar, 16:29

Breck%20Carter's gravatar image

Breck Carter
29.9k490664971
accept rate: 20%

Hexplorer was quite useful, Breck. Thank you very much.

It was also able to verify that the data that predates the...

ALTER TABLE <table_name> ENCRYPTED;

...being applied does indeed become encrypted.

  • John Strano
(16 Mar, 09:04) appdev

To determine whether a database is encrypted, you can fetch select db_property('encryptionscope'), which returns 'None' if the database is not encrypted, 'Tables' if table encryption is enabled, or 'Database' if the database is fully encrypted.

If you want to verify that the actual data written to the disk is encrypted, there is no way through SQL or any other interface to retrieve the ciphertext. You'd have to examine the contents of the database file itself.

permanent link

answered 13 Mar, 16:08

Graeme%20Perrow's gravatar image

Graeme Perrow
9.4k377121
accept rate: 53%

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:

×137
×45

question asked: 13 Mar, 16:03

question was seen: 103 times

last updated: 16 Mar, 09:05