I want to know if its possible for the TDE to store in the encrypted column the ciphertext instead of the cleartext because now everyone can see the data still in plaintext. i also tried to export the data from the table which has the encrypted column in excel and it still shows the column in plaintext meaning anyone can read the sensitive information i wanted to encrypt.I followed step by step,created the wallet and everything.
Please help?
eg instead of :
ID NAME Salary
1 James 1000
I want it to show like the following:
ID NAME Salary
1 James hhdjdy37y474h4755hh