title: How can I lock stored procedure in SQL Server?
body: <p>How can I lock my stored procedure so that users cannot modify, but users can see it?</p>
  
  <p>Like this: some stored procedure is locked for all users, and some is unlock.</p>
  
  <p>Like this image</p>
  
  <p><img src="https://i.stack.imgur.com/G99qk.png" alt="enter image description here"></p>
  
  <p><a href="https://i.stack.imgur.com/G99qk.png" rel="nofollow noreferrer">http://i.stack.imgur.com/G99qk.png</a></p>