read only Stored Procedures?

Is there a way to make Stored Procedures "read only" or make it so no one can
modify the SP?Yes, just don't give users who shouldn't be to change procedures permissions
to do so. If it is an existing problem, remove the relevant users from the
sysadmin, db_owner and db_ddladmin roles. Then you can either REVOKE or DENY
the CREATE PROCEDURE statement to the users.
--
Jacco Schalkwijk
SQL Server MVP
"J Jetson" <JJetson@.discussions.microsoft.com> wrote in message
news:638520E1-FB4D-4960-8345-56A174249A45@.microsoft.com...
> Is there a way to make Stored Procedures "read only" or make it so no one
> can
> modify the SP?