|
I want to encrypt and decrypt the all columns in the table. With the following i m able to encrypt/decrypt only one column in the table.
--Sample table
Procedure to Insert Data in Table
--Insert Procedure
-- Procedure to Retrive Users
Please help me to encrypt/decrypt all the columns in the table. Thank you A later question (duplicate; now closed) was asked by the same person with the following additional comment:
(comments are locked)
|
|
What you're describing isn't TDE.
This will encrypt everything in your database file. You can still read it, but the file and backups will now be encrypted - no-one will be able to access your data except through proper db connections.
(comments are locked)
|
|
If you have some reason why you don't want to use TDE, then you are stuck applying the encrypt functions to each column individually, effectively repeating the type of code you already have.
(comments are locked)
|

