Can I set up an Oracle Database in a way that all of the following statements are true
a) certain columns, potentially all columns are encrypted, so that direct file access to the database file wouldn't allow an attacker to retrieve any records
b) the encrypted columns are transparently decrypted for authorized user, where authorizatio...
Is it possible to take a database that is using TDE and create a backup file that is not encrypted?
I know that I could create a backup, import into another database (using the key and certificate), turn off TDE and create a backup.
I'm wondering if there is a more straight forward approach.
...
My question is a duplicate of - http://stackoverflow.com/questions/2230189/oracle-transparent-data-encryption-undecrypted-access - but for SQL Server 2008.
Can I set up a SQL Server 2008 database in a way that all of the following statements are true?
a) certain columns, potentially all columns are encrypted, so that direct file acce...