Re: Execute permission for all sprocs

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 06/09/05 

Date: Thu, 9 Jun 2005 18:33:02 +0100

sp_grantexec
http://www.sqldbatips.com/showcode.asp?ID=2 

-- 
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Craig HB" <CraigHB@discussions.microsoft.com> wrote in message 
news:A903026B-14A6-40F0-9FB0-52906A69026C@microsoft.com...
>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: Getting a list of Stored Procedures
    ... permissions associated with an object.... ... Wayne Snyder, MCDBA, SQL Server MVP ... community of SQL Server professionals. ... "Craig G" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • Re: How can I use MDX functions in SQL Query Analyzer (Client Tool)
    ... Jasper Smith (SQL Server MVP) ... community for SQL Server professionals - ... > somethingI need to enable, install, configure, tweek, activate, ...
    (microsoft.public.sqlserver.clients)
  • Re: Another 17055 error problem
    ... Jasper Smith (SQL Server MVP) ... >>That just looks like you have Auditing set to either ... >>community for SQL Server professionals - ...
    (microsoft.public.sqlserver.security)
  • Re: JOBS
    ... >Jasper Smith (SQL Server MVP) ... >community for SQL Server professionals - ... >>Give the user in question permission to exec these procs. ...
    (microsoft.public.sqlserver.security)
  • Re: using certain port for sql server 2000
    ... > community of SQL Server professionals. ... not to be overly picky, but you should fix your signature. ...
    (microsoft.public.sqlserver.server)