Re: Grant Execute to user on procedures

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 07/04/04

  • Next message: FabriZio: "Help" 
    Date: Sun, 4 Jul 2004 01:53:41 +0100

    Have a look at

    Granting execute permissions to all stored procedures in a database
    http://www.sqldbatips.com/showarticle.asp?ID=8

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

    You can use this like

    exec sp_grantexec 'ABC','MTS%' 

    -- 
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
"Bent Lund" <bstlu@online.no> wrote in message
news:ucjryKQYEHA.3012@tk2msftngp13.phx.gbl...
> Hi,
>
> is there a easy way of grantinng Execute-privilegies to user ABC for all
> procedures named 'MTS*' in a database?
>
>
>
> regards,
>
> Bent S. Lund
> System Developer
> MCP VB
>
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!
  • Next message: FabriZio: "Help"

    Relevant Pages

    • Re: Database Model - Class, objects and interaction
      ... I was just proving stored procedures can call views. ... stuff like security and logging. ... So given 100,000 users, you would create database accounts for each? ... Part of our system's integrity was its reliability, and reliability is often assisted by simplicity. ...
      (comp.object)
    • Re: Database Model - Class, objects and interaction
      ... Stored procedures should only be used as a last resort if you cant use ... I've not said that views shouldn't be created, only that they shouldn't be exposed as the interface to the database. ... But business rules can be more complicated than simply defining overdue invoices. ...
      (comp.object)
    • Re: Infinite Loops and Explicit Exits
      ... the whole payroll system would be dependent on proper database ... I design large systems the same way. ... Stored procedures ARE application code. ... any language, including Cobol. ...
      (comp.lang.cobol)
    • Re: Identity Column
      ... the end use is using Crystal Reports - where is the magic? ... The user will connect using Active Directory from their desktop to the database server or do please explain the magic.... ... Using stored procedures you permission on the stored proc only; the user can only execute the stored procedure with the parameters defined, there is no select * from to get all the information in your database. ...
      (microsoft.public.sqlserver.programming)
    • Re: Infinite Loops and Explicit Exits
      ... The behaviour could only be changed by changing the database. ... >>designing proper databases and using stored procedures on them, ... are database dependent and not available in COBOL. ... But with extended SQL you simply write the procedures in SQL ...
      (comp.lang.cobol)