Database Security Products (MOSC)

MOSC Banner

Oracle 11g encryption data test

edited Nov 23, 2009 4:58AM in Database Security Products (MOSC) 4 commentsAnswered
Hi

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center