Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Maysam
Starting Member
8 Posts |
 Posted - 2011-03-02 : 15:55:38
|
| I am not sure if this question has been already asked or this question falls into this category ... so If it doesn't "Sorry"I read that one of the ways to protect source code is adding signature to the object. I created a certificate and then created a user-defined stored procedure and then add a signature to the stored procedure....My question is how can I test this signature? nothing has changed, it seems that signature does not do anything ...I need help with "Signature", I appreciate your help...Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-03-02 : 16:25:43
|
| If you're talking about the ADD SIGNATURE command, that doesn't encrypt the source code. It's used to grant permissions via certificate, rather than user privileges.To encrypt T-SQL procedure/function/view definitions, you need to add ...WITH ENCRYPTION to the CREATE statement. Make sure you have unencrypted copies of the code in source control, you cannot extract it from the database (not natively anyway). |
 |
|
|
|
|
|
Encrypting Source Code