| Transparent Data Encryption [message #323222] |
Tue, 27 May 2008 16:35  |
Duane
Messages: 581
Registered: December 2002
|
Senior Member |
|
|
The DBA/server guys set this up but how do I know it's working? When viewing the table data using Toad, the data in the column is plain text. I'm thinking that the data in that column shouldn't be readable but maybe Toad is making the conversion. I do know that once TDE is set up, you can use "select encrypted_column from table_name" and it will convert the data for you.
Any way to check to ensure the column data is indeed encrypted?
|
|
|
|
| Re: Transparent Data Encryption [message #323254 is a reply to message #323222] |
Tue, 27 May 2008 23:01  |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
| Quote: | The DBA/server guys set this up but how do I know it's working?
|
As end user you can't know it by reading the table, it is the purpose of "Transparent".
| Quote: | Any way to check to ensure the column data is indeed encrypted?
|
You can for instance ask your DBA to close the wallet then you can no more see the data.
You can also query ALL_ENCRYPTED_COLUMNS and see if your column is in.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
