title: Granting Select Rights to a Stored Procedure in SQL Server 2000
body: <p>I want to give a user access to a stored procedure, but not to all the objects in the database the stored procedure needs to use.</p>
  
  <p>What is the best way to give rights to the stored procedure to enable it to work, but only grant execute access to the user to run it.</p>
  
  <p>I am using sql server 2000 sp4.</p>