What permissions does the MS SQL user need on the database to execute a stored procedure? By execute it I mean they can run it and read the data. I don't want them to have permissions to any other tables or areas of the DB.
Do they need permissions to the tables that the Stored Procedure queries?
Do they need permissions to the database which contains the stored procedures?