Originally posted by blindman
I think he wants to prevent changes to the procedure code, Brett.
Look up CREATE PROCEDURE in Books Online, and you will see there is an option called WITH ENCRYPTION.
I will warn you that the encryption is not very strong, and methods of breaking it have been posted on the internet.
Thanks. You are correct. I have used
CREATE PROC name
From T-SQL definition, the users who are not allowed access the database cannot change SPs that are stored in syscomments table. I am wondering if the users who are clients of database can access the SPs.