How to protect a stored procedure

How to protect a stored procedure

Post by Bria » Fri, 01 Nov 2002 00:17:58



How does one "protect" a stored procedure from being
overwritten by another script?

Thanks,
Brian

 
 
 

How to protect a stored procedure

Post by Anith Se » Fri, 01 Nov 2002 00:32:42


Grant execute only permissions to the stored procedure. SQL
Server Books Online has a detailed section about how to grant
& revoke permissions. If you want to hide the script from
being displayed you can use the WITH ENCRYPTION option while
creating the stored procedure. Note that you cannot decrypt
an encrypted procedure and so you must store the unencrypted
code somewhere else in case you need to make any changes.

--
- Anith