Home » RDBMS Server » Security » TDE implementation / data encryption problem (merged)
TDE implementation / data encryption problem (merged) [message #352872] Fri, 10 October 2008 00:01 Go to next message
rahulsql
Messages: 18
Registered: August 2008
Junior Member
hi
we are using the front end as java and back end as oracle(10.2).

we tested TDe . we are facing some problem in that.

when wallet is open then only we can able to see the encrypted column value.

the user who is using the application in real time he enters the vlaues in front end application form that vlues should be inserted in database.if wallet is closed the values entered in front end form are not inserted in database.
how to solve this problem.
we can solve this problem by below methods
(1)the values entered in the front end by user are stored in temporary tables then from temp tables these values are inserted in to actual tables.is this solution is correct.(2) we have to store values in views then inserted into actual tables

is my approach solve the problem .which one is correct .if both are not workout then mention the actual solution to this problem
Re: TDE implementation problem [message #352879 is a reply to message #352872] Fri, 10 October 2008 00:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
how to solve this problem.

Which problem? This is how TDE works. If this does not fit what you want then you are using the wrong tool.

Quote:
(1)the values entered in the front end by user are stored in temporary tables then from temp tables these values are inserted in to actual tables.is this solution is correct

No. Why using temporary tables?

Quote:
(2) we have to store values in views then inserted into actual tables

Use instead of trigger.

Quote:
is my approach solve the problem

Maybe yes, maybe no, we don't know your business need.

Quote:
.if both are not workout then mention the actual solution to this problem

Impossible to say until you tell us what is your business need.

Regards
Michel

data encryption problem [message #352885 is a reply to message #352872] Fri, 10 October 2008 00:42 Go to previous messageGo to next message
rahulsql
Messages: 18
Registered: August 2008
Junior Member
we are using 10.2 version.we are using java as fron end.our require ment is the data entered
from front end form is to be stored as encrypted format in the data base tables.the data
stored in the tables is visible to only authorised persons.and also data inserted from
front end is inserted in tables in encrypted format.

for this requirement is TDE suitable or not?

when we Use TDE wallet is closed then only the data not visible so security is present.if we
close wallet the data from front end is not inserted to data base tables.it shows error as wallet is closed.

for this suggest a solution
Re: data encryption problem [message #352886 is a reply to message #352885] Fri, 10 October 2008 00:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't multipost your questions, they will end up at the same place.

Regards
Michel
Re: data encryption problem [message #352887 is a reply to message #352885] Fri, 10 October 2008 00:49 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
the data
stored in the tables is visible to only authorised persons.and also data inserted from
front end is inserted in tables in encrypted format.

for this requirement is TDE suitable or not?

No. TDE purpose is to protect data against file theft.

Quote:
for this suggest a solution

Many ways:
* Views
* FGAC (Fine-grained access control)
* Data encryption at DB (dbms_crypto) or application (Java encryption toolkit) level.

Regards
Michel
Previous Topic: problem log in wiht SYS
Next Topic: ERROR: ORA-01017 in ORACLE 11g
Goto Forum:
  


Current Time: Mon Dec 05 08:49:50 CST 2016

Total time taken to generate the page: 0.10051 seconds