How to encrypt stored procedure in SQL Server ?

Posted by Sksamantaray under Sql Server on 12/29/2011 | Points: 10 | Views : 1808 | Status : [Member] | Replies : 4
Can someone show how to encrypt/decrypt stored procedure in sql server with examples.

Thanks,
Sanjay



Responses

Posted by: Naraayanan on: 12/29/2011 [Member] Starter | Points: 25

Up
0
Down
check this link
http://social.msdn.microsoft.com/forums/en-US/sqlsecurity/thread/1d8ec222-8ace-4665-aefb-e39097a7566c/

Regards,
Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/
http://abaprocker.blogspot.com/

Sksamantaray, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Self-innovator on: 12/30/2011 [Member] Bronze | Points: 25

Up
0
Down
create proc sp_FillEmp with encryption as

begin
select * from Employees
end


Join Hands Change lives
Thanks & Regards
Straight Edge Society

Sksamantaray, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sksamantaray on: 12/30/2011 [Member] Silver | Points: 25

Up
0
Down
Thanks ,Self-innovator
But how to decrypt it?
Give an example

Thanks,
Sanjay

Sksamantaray, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Self-innovator on: 1/1/2012 [Member] Bronze | Points: 25

Up
0
Down
better try this link..
even i looks to decrypt the sp
http://forums.asp.net/t/1516587.aspx/1

Join Hands Change lives
Thanks & Regards
Straight Edge Society

Sksamantaray, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response