Sitemap

Amicuk Programming Answers

Encrypt procedure

-0001-11-30   Views:0

Advertisement

I, wanted to know that how, can we encrypt a procedure in Oracle. As, per my knowledge, this is generally done so that unwanted people cannot read the code of the procedure. I hope, my question is clear. Please, help in solving the doubt. regardsuser

I, wanted to know that how, can we encrypt a procedure in Oracle. As, per my knowledge, this is generally done so that unwanted people cannot read the code of the procedure.
I hope, my question is clear.
Please, help in solving the doubt.
regards

The replay answer
Advertisement
user574290 wrote:
hi,
thanks, for your answer. But, this talks more of encryting pl/sql code in a file. I wanted to see this encrytion when I access the procedure from TOAD. I think, it is possible.
I hope, my question is clear.
Please, help in solving the doubt.If you actually read about "wrap" it encrypts your source file code. You then run that encrypted source file code against the database, just as you would if it were not wrapped, and then the code stored on the database also becomes encrypted. It's very simple and, by now, you could have tried it to see for yourself.

Go to See the other 9 answers

Encrypt procedure in oracle

Category:DefaultRelease time:-0001-11-30Views:130

How to encrypt the procedure in oracle use wrap? Pls tell me the way and step.check this dude: http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/c_wrap.htm#2062 succes.Read other 2 answers[More]

Encrypt procedure

Category:DefaultRelease time:-0001-11-30Views:130

I, wanted to know that how, can we encrypt a procedure in Oracle. As, per my knowledge, this is generally done so that unwanted people cannot read the code of the procedure. I hope, my question is clear. Please, help in solving the doubt. regardsuser[More]

Third part encryption procedure

Category:DefaultRelease time:-0001-11-30Views:130

Is there a third party (from an Oracle partner) procedure to encrypt data with a 128 bits key algorithm?.Is there a third party (from an Oracle partner) procedure to encrypt data with a 128 bits key algorithm?.Read other 4 answers[More]

Get error message from a nested/encrypted stored procedure

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have an encrypted procedure, that is used inside my 'own' complex procedure as: Begin try Begin tran Do a lot insert into #tmp exec xp_encryptedSP Do a lot more commit tran end try begin catch print ERROR_MESSAGE() rollback tran end catch Some[More]

AES encrypt/decrypt

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I need to encrypt a file in Java using AES, given an 'EncryptionKey'. The "EncryptionKey" will be given to me as a String. Later, the client needs to be able to decrypt it using the same "EncryptionKey", with ANY decryption tool. I[More]

Encrypting data and using a funtion

Category:DefaultRelease time:-0001-11-30Views:130

I am using dbms_obfuscation_toolkit.DESEncrypt This is a procedure. so if i need to encrypt data, I have to do it row by row. I actually need to update records to make them encrypted so its cursor run encrypt procedure update this is really slow. any[More]

How to cancel filevault encryption process midway, since it is demanding 12 hours

Category:DefaultRelease time:-0001-11-30Views:130

After upgrading to OS-X Yosemite version 10.10, I enabled filevault encryption option. Since then whenever I connect to the electric power, the disk starts encrypting procedure. I try to turn it off, it says to wait until the file encryption complete[More]

IS Transperent Data Encryption is secure from DBA?

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, I want to encrypt some of data, for that i learn about Transperent Data Encryption, But i have doubt that TDE cant able to provide security against DBA. I want your valluable comment on this. and I want to know, is there any other way to secu[More]

Administrator Password Change

Category:DefaultRelease time:2015-10-11Views:130

Hi, After changing the default Administrator Password in the RPD, I ran the Cryptotools utility for both BI publisher and BI Scheduler to make sure that the BI Presentation services can identify the CredentialStore. There is another xml file, xmlp-se[More]

Oracle upgrade problem from 8.1.6.2.0 to 9.2.0.3.0

Category:DefaultRelease time:2015-10-11Views:130

We have upgraded our database to version 9.2.0.3.0 from version 8.1.6.2.0. Everything is fine accept a proprietory encryption package that utilises the UTL_RAW package and stores working variables in a PL/SQL Record structure consisting of 6 RAW(4) f[More]

DBMS_CRYPTO error

Category:DefaultRelease time:-0001-11-30Views:130

Hi I have problem using dbms_crypto package. If I execute this code: declare   c_text clob := to_clob('TEST TEXT');   b_result blob;   function crypt (ac_text clob) return blob as      secret_key   RAW (32) := utl_raw.cast_to_raw('1234567890123456789[More]

Hot
Open VI reference seems to run in the user interface thread. If you open a user dialog all the open vi reference functions halt until the dialog has been closed (even though they run in paralell loops etc, no data flow explanation). MTO> Loading and [More]
What is the best way to migrate my MacBook Pro to my new Imac desk top, both seem to be running OS X version 10.9.5OS X: How to migrate data from another Mac using MavericksRead other 2 answers [More]
Does anyone know if it's possible to change the default monitor refresh rate of an iMac in Open Firmware and how? Thanks.Thanks but I think the iMac G5 does have a refresh rate or something analogous to one, in this case I believe it is 60 hertz. I w [More]
Hello, What is the easiest way to export tracks so I can bring into another program (that doesn't have OMF capability). I don't want to have to do a process that takes alot of time. Any ideas wiould be appreciated. Regards, RichFile>Export>Export Al [More]
Hi all, i am new to abap objects. Can anyone help me how to create ALV program . it will developop in  tree or  hierarchy for.. folder1 -- level 1 subfolder1 -- level 2 *********subfolder1 -- level 3... Please send One Simple Code to develop this Obj [More]
Hi All, I am working on ADOBE Forms.I have a standard adobe form 'LSO_PWB_COVER_PREBOOK'. In the standard adobe form field variables are defined.without any fields visible.I want to know how these fields are Defined. Can anybody please let em know ho [More]
I bought the ilife'06 DVD and no matter how many times i've tried, it won't install GarageBand 3. I tried to 'customize' install and it didn't work. Everything else updated (i.e. imove6, iphoto6 etc). Can anyone help me? I have an ibook G4-OS version [More]
Post Author: SSVXI CA Forum: Charts and Graphs CR XII am trying to have row numbers in a crosstab.  I normally do this when not using a crosstab with a running total, but a running total is not available to add to the crosstab ROW listing.  For examp [More]
We received an email on the iPad that purports to be from Amazon, recommending books to download.  It's obviously a phishing email, but the problem is that we can't delete it.  When we select the Delete icon, the email just stays on the iPad.  This e [More]
Help again, I understand what happens when IPHONE is restored again. However, here's the real problem: I updated with ITUNES latest version and my phone said there was an unexpected error when updating and now it's showing the itune logo and a usb po [More]