GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Concepts and Architecture
Go To First  |  Previous Question  |  Next Question 
 Concepts and Architecture  |  Question 69 of 74    Print  
how to encrypt and decrypt oracle procedure

  
Total Answers and Comments: 3 Last Update: January 30, 2009     Asked by: JOGINDER 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
November 25, 2007 07:16:54   #1  
Tauseef        

RE: how to encrypt and decrypt oracle procedure
by using the WRAP utility
 
Is this answer useful? Yes | No
December 21, 2007 16:23:35   #2  
ddf_dba Member Since: December 2007   Contribution: 2    

RE: how to encrypt and decrypt oracle procedure
The WRAP utility 'wraps' or hashes the PL/SQL source code but will not 'unwrap' it to restore the plain text starting point. Oracle can decipher this 'translation' internally however to edit the code one must retain the plaintext source.

WRAP is intended to obfuscate source code distributed to client sites in an effort to prevent prying eyes from seeing the underlying logic and to prevent any unauthorized code modification by the client.

Again there is no UNWRAP utility so once code is WRAPed it remains such to the naked eye.

 
Is this answer useful? Yes | No
January 30, 2009 11:58:14   #3  
akebono Member Since: November 2005   Contribution: 1    

RE: how to encrypt and decrypt oracle procedure
DBMS_OBFUSCATION_TOOLKIT package is a simple API for data encryption
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape