Sometimes for security reason it is require to encrypt the objects which you have created (Suppose you have deployed your database on client end or shared hosting and you don’t want any other person to see your logic behind your stored procedure and function).
To achieve this you need to use a simple keyword encryption
In below example I have encrypted the proc_GetListUser
Now when someone try to see the content of stored procedure generally he/she will write following command
sp_helptext proc_GetListUser
When he/she will run this command he will get encryption message not the stored procedure content.
Hope you will use this tip soon.
Cheers!
sir ji grt
ReplyDelete