Oracle 11g encryption data test
1.I created a tablespace with encryption.
2. Created new table 'A' in the encrypted tablespace.
3. Add values to the new table 'A'.
4. Alter system flush buffer cache;
5. Used Toad, to Query the values from table 'A'.
I see the data in regular form (not encrypted).
What is the use of having tablespace encryption, when someone can view the data in encrypted tables same as a regular tablespace?
My understanding is that any object belonging to encrypted tablespace, will have the data in encrypted form, so it is not visible to every user.
Please advice.
Thanks