cancel
Showing results for 
Search instead for 
Did you mean: 

Verifying Table Data is Encrypted with Simple

1,544

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?

Accepted Solutions (1)

Accepted Solutions (1)

Breck_Carter
Participant
0 Kudos

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

Answers (1)

Answers (1)

graeme_perrow
Advisor
Advisor

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.