OraFAQ Forum: Security » TDE implementation / data encryption problem (merged)

Home » RDBMS Server » Security » TDE implementation / data encryption problem (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TDE implementation / data encryption problem (merged) [message #352872]

Fri, 10 October 2008 00:01

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

Report message to a moderator

Re: TDE implementation problem [message #352879 is a reply to message #352872]

Fri, 10 October 2008 00:35

Michel Cadot
Messages: 67769
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

Report message to a moderator

data encryption problem [message #352885 is a reply to message #352872]

Fri, 10 October 2008 00:42

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

Report message to a moderator

Re: data encryption problem [message #352886 is a reply to message #352885]

Fri, 10 October 2008 00:45

Michel Cadot
Messages: 67769
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

Report message to a moderator

Re: data encryption problem [message #352887 is a reply to message #352885]

Fri, 10 October 2008 00:49

Michel Cadot
Messages: 67769
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Mar 06 08:58:32 CST 2021