Expert Must Suggest How to encrypt Stored Procedure..??

Question

Expert Must Suggest How to encrypt Stored Procedure..??

shashi kant

SSCommitted

Points: 1659
More actions
January 21, 2007 at 10:42 pm

#153394

Hi all Experts
I just want to know , is there any technique to encrypt the stored procedure coding so that no one can easily read this sp.and normal user have to apply lots of efforts to decrypt it.
If any one expert have some technique related to this then just let me know with decrypt technique . so that we can try this and expend our knowledge related to sql encryption and decryption..

Thanx in advance........

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

hr_sn Ten Centuries Points: 1092 More actions · Answer 1

Yes you can encrypt stored procedure's, Check for WITH ENCRYPTION in BOL. But this is not 100% safe as there are heaps of methods available by which you can decrypt them very easily.

shashi kant SSCommitted Points: 1659 More actions · Answer 2

Hi Author

U mean Like this

* Stored Procedure to insert a new record in

the Sample Table */

CREATE PROCEDURE sp_AddRecordToSampleTable

@SampleIdNo int,

@SampleName VARCHAR(20),

@SampleDesc VARCHAR(200)

WITH ENCRYPTION

AS

BEGIN

/* Add record into the table using the values given

by the user*/

INSERT INTO SampleTable(SampleIdNo, SampleName, SampleDesc)

VALUES(@SampleIdNo, @SampleName, @SampleDesc)

END

go

if so is there any other alternative of encryption or decryption

Sergiy SSC Guru Points: 110208 More actions · Answer 3

Set up proper security model and don't give sa password to anybody.

_____________
Code for TallyGenerator

shashi kant SSCommitted Points: 1659 More actions · Answer 4

password security is not benifit to me for my question

Sergiy SSC Guru Points: 110208 More actions · Answer 5

How deep is your knowledge of SQL Server sequrity?

What makes you believe your statement is correct?

_____________
Code for TallyGenerator