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
I am testing our website :www.winningsportstips.com and we have Virtuemart installed and the site will not allow me to select 'add to cart' feature. However if I open the website in Internet Explorer, the feature is available and it functions correct [More]
hello guys. I have a main form which also serves as a search form. initialy this form displays some data. in one of my menu I have a command link that executes create and takes me to the create form. my problem is that when I click on the command lin [More]
I purchased the Universal Dock back when it came out. Now I have upgraded to a new Classic & iPhone and neither seem to work to the TV through it. I took having to spend another $49 on the chin and bought the new composite AV cable, which by the way [More]
I'm relatively new to Apple and iTunes.  If I "add folders" that contain 1000s of songs from my hard drive to the iTunes library...does iTunes copy/create new files that essentially double the amount of space taken up on my hard drive, or does i [More]
Hello, In a sales order( a debit memo for example), we can insert different condition types in the pricing elements, from the Conditions tab. I know these conditions are assigned to CO-PA value fields. My question is where are the condition types and [More]
click on email the email opens to full screen.click on to move screen,the page opens upSounds like your mouse is going bad and issuing a double click when you single click. Do you have another mouse to try?Read other 3 answers [More]
I am using OS 7 on my iphone 4s and iPad 2 an am unable to set up icloud for the Find Me App. I am redirected to the icloud section of settings to sign in but there is no place to do so.Are you using mobile Safari on the iphone to log into icloud.com [More]
I am in the process of upgrading from iMS 5.2 w/iDS 4.16 on an NT box to iMS 5.2 w/iDS 5.1 on Solaris 9. And , yes I am new to solaris, but that is another story..... I have successfully installed solaris, iDS 5.2, run the ims_dssetup.pl script, inst [More]
Hi, on MSSQL we have 3 data files and 1 trans log file. Becouse of 2quad core procesors on DB host we want to have 8 data files equally occupied. Any idea how to do that on MSSQL level? UrbanHi, Because of 2quad core procesors on DB host we want to h [More]
Hello, last night i was on my laptop and it was working fine. I turned it off then in the morning i noticed the the hp logo on the back was on but the computer was off so I disconnected the battery then reconnected it and pressed the power button the [More]