Execute permission for all sprocs

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

Date: Thu, 9 Jun 2005 07:38:05 -0700

I am looking to write a script that will grant a specified user execute
access to all stored procedures, but no other permissions

Any help would be appreciated,
Craig

Relevant Pages

  • RE: permission to review jobs and settings
    ... and then grant the permissions to the user. ... stored procedures will call other system stored procedures. ...
    (microsoft.public.sqlserver.security)
  • Re: permission to review jobs and settings
    ... can assign read-only types of permissions on tables. ... > which need to be queried, and then grant the permissions to the user. ... > stored procedures will call other system stored procedures. ...
    (microsoft.public.sqlserver.security)
  • Re: Granting create table to database role
    ... In our company we gave permissions only for EXECUTION on stored procedures ... If you want the users to be able SELECT/UPDATE/DELETE/INSERT don't grant ...
    (microsoft.public.sqlserver.security)
  • Re: Preventing unauthorized access
    ... Use only stored procedures to access the database in your application. ... not grant any permissions on tables or views to users; ... permissions on stored procedures. ...
    (microsoft.public.sqlserver.security)
  • Re: USERS group has the ability to change security permissions???
    ... Please use the Advance view in the NTFS permissions dialog to ... When there is a generic grant and a special grant to the same entity ... the RESULT: user level access can change NTFS ...
    (microsoft.public.win2000.security)