You can encrypt a view or an SP in SQL server 2005 by using the key work "with encryption" while creating the SP or View.
Please look into the example below.
create procedure MySp with encryption
as
begin
select * from EmailList
end
Once you created an sp or view with the above option added then it cannot be viewed by any users.if the suer tryes to view the above sp orview then it SQL server will show a message like . The text for object 'MySp' is encrypted.
One note of caution. Save the original text of the stored procedure before encrypting it, as there is no straightforward way to decode the encrypted text. One hack is to attach a debugger to the server process and retrieve the decrypted procedure from memory at runtime
Please look to the below link for how to decrypt the encrypted Sp or view.
http://www.sql-shield.com/decrypt-stored-procedure.html
Please look into the example below.
create procedure MySp with encryption
as
begin
select * from EmailList
end
Once you created an sp or view with the above option added then it cannot be viewed by any users.if the suer tryes to view the above sp orview then it SQL server will show a message like . The text for object 'MySp' is encrypted.
One note of caution. Save the original text of the stored procedure before encrypting it, as there is no straightforward way to decode the encrypted text. One hack is to attach a debugger to the server process and retrieve the decrypted procedure from memory at runtime
Please look to the below link for how to decrypt the encrypted Sp or view.
http://www.sql-shield.com/decrypt-stored-procedure.html
No comments:
Post a Comment