Re: GRANT - Execute SP

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 08/19/03

  • Next message: Rafael Wittek: "Re: prevent updates/deletes on certain rows" 
    Date: Tue, 19 Aug 2003 07:56:45 +0100

    And one could argue that since any changes to a production environment
    should go through a release process, these change(s) will be reflected in
    your source control system and so you would have the necessary permission
    grants in your change script/release pack :-) 

    -- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Kalen Delaney" <replies@public_newsgroups.com> wrote in message
news:emKqcddZDHA.736@TK2MSFTNGP09.phx.gbl...
Clever idea! However, keep in mind that both this solution only works for
existing stored procedures, so when you create a new procedure, it will have
to have permissions granted on it. (In comparison, the db_datareader role
gives permission on all TABLES, whenever they are created.)
--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Jasper Smith" <jasper_smith9@hotmail.com> wrote in message
news:OBWdHOdZDHA.1004@TK2MSFTNGP12.phx.gbl...
> Run the following in QA and copy and paste results to give you the
required
> script.
>
> select 'grant exec on ' + QUOTENAME(name) + ' to [your_role]'
> from sysobjects where type = 'P'
> and objectproperty(id,'IsMSShipped')=0
>
> --
> HTH
>
> Jasper Smith (SQL Server MVP)
>
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Gary L." <hh_kennel@hotmail.com> wrote in message
> news:01b001c365a9$f3bca210$a301280a@phx.gbl...
> I want to grant a login name global access to execute
> stored procedures in my database.  I've found that I can
> grant exec to each sp individually, but surely there's a
> way to do this globally.  Any help is appreciated?
>
>
  • Next message: Rafael Wittek: "Re: prevent updates/deletes on certain rows"

    Relevant Pages