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 |
|
hendrasd
Starting Member
20 Posts |
 Posted - 2003-07-09 : 21:32:12
|
| Is there any way to encrypt a stored procedure without adding the keyword with encryption to the stored procedure ? I tried to change the column encrypted in syscomments, but SQL Server does not allow to change the content system catalog, and the encrypted column is a computed column so it cannot be change.Thanks in advance ...-- Never stop learning -- |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-07-09 : 21:54:43
|
| A. DO NOT MODIFY OR TRY TO UPDATE THE SYSTEM TABLES OR THEIR DATA.B. DO NOT ENCRYPT YOUR PROCEDURES OR VIEWS IF YOU ARE NOT KEEPING THE UNENCRYPTED SOURCE CODE IN A SOURCE CONTROL SYSTEM.C. DO NOT ENCRYPT STORED PROCEDURES, USE PROPER SQL SERVER SECURITY TO PREVENT PEOPLE FROM ACCESSING THE PROCEDURES IN THE FIRST PLACE.You can't encrypt the source code of a stored procedure except to use WITH ENCRYPTION, and even if you could you'd get no benefit and a lot of problems. If you are not 100% absolutely sure or comfortable with encryption then you should not be using it. |
 |
|
|
|
|
|
Encrypting Stored Procedures