on 2020 Mar 13 4:03 PM
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?
Hexplorer is very handy for this.
See also this related question: https://sqlanywhere-forum.sap.com/questions/34024/how-do-i-encrypt-old-rows-after-alter-table-encryp...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
70 | |
10 | |
9 | |
6 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.