SP execute only permissions

From: Craig HB (CraigHB_at_discussions.microsoft.com)
Date: 06/13/05 

Date: Mon, 13 Jun 2005 02:07:04 -0700

I want to give a user execute permissions on all the stored procedures in a
database and nothing else. Is there a fixed database role that I can use, or
do I need to grant the user permissions for each stored procedure manually ?

Thanks,
Craig

Relevant Pages

  • Re: SP execute only permissions
    ... Mike Epprecht, Microsoft SQL Server MVP ... >I want to give a user execute permissions on all the stored procedures in a ... Is there a fixed database role that I can use, ...
    (microsoft.public.sqlserver.security)
  • Re: Create Table and Stored Procedures
    ... db_datareader fixed database role so they can access the underlying ... > programmers to create stored procedures and views, ... > block stored procedure/view creation? ...
    (microsoft.public.sqlserver.security)