dsemwal

 Profile Answers by dsemwal 

• Jan 8th, 2007

 

To hide the code you need to wrap the SP(Stored procedure), you can see google for how to wrap SP. wrapping the Sp is like encrypting the SP, and can be done using simple command, don't remember this time exactly teh command.

sourav

• Jan 18th, 2007

 

One can wrap  in oracle Procedure by folowing way:-

write in command promt or in to path Oracle Bin folder:-

wrap iname= pathfilename.sql oname=pathwrapfilename.sql

then in path wrapfilename.sql encripted file will be genarated .Just run it in sql promt

@pathwrapfilename.sql

Procedure are wraped.

Exaple procedure file created in c:promyprocedure.sql

wrap iname= c:promyprocedure.sql oname=c:prowrapfilename.sql run it oracle sql prompt

@c:prowrapfilename.sql

Procedure created

This procedure may any procedure.

vavasudevan

 Profile Answers by vavasudevan 

• Feb 13th, 2007

 

Hi,Even we can use "Encryption" Keyword in MSSQL with Proc... this'll hide text of the Proc from User.Eg.,Create Proc Proc1As Select 1 While Taking sp_HelpText for Proc1, it'll return text written inside proc but......Create Proc Proc2With EncryptionAs Select 1 While Taking sp_HelpText for Proc2, it'll return Error saying as the "The object comments have been encrypted."RegardsVijay :)

kirandba

 Profile Answers by kirandba 

• Mar 31st, 2010

 

CREATE PROCEDURE xyx
WITH ENCRYPTION
AS
BEGIN
.
.
.
END

But you need to know database master key to decrypt this stored procedure to view code.