Home » RDBMS Server » Security » Transparent Data Encryption
Transparent Data Encryption [message #323222] Tue, 27 May 2008 16:35 Go to next message
Duane
Messages: 557
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 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: How to know the last access to a table?
Next Topic: How to know the actual password (not hashcode) of any user as a DBA
Goto Forum:
  


Current Time: Thu Mar 28 16:22:16 CDT 2024