5. Using Data at Rest Encryption : Transparent Column Encryption : Access Enabled for New Tables
 
Share this page                  
Access Enabled for New Tables
When you create a table with encryption, it automatically unlocks the table as if you had issued the MODIFY...ENCRYPT WITH PASSPHRASE= statement, so can insert data into the new table without having to issue the MODIFY to access it.
If you are not going to allow access to the new table immediately, you must issue the MODIFY tablename ENCRYPT WITH PASSPHRASE = ' ' to disable access to the table.