Re: Grant Execute to user on procedures

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/03/04

  • Next message: Jasper Smith: "Re: Grant Execute to user on procedures" 
    Date: Sat, 3 Jul 2004 21:20:12 +0530

    Hi,

    In Query Analyzer execute the below script with Text result.

    Use <dbname>
    go
    select 'grant execute on '+name +' to ABC' from sysobjects where name like
    'MTS%' and type='P'

    -- The above script will generate a script to grant execute previlage to ABC
    user for all procedures start with MTS%.

    Copy the result window and paste in a new Query analyzer window and execute
    it.

    Thanks
    Hari
    MCDBA

    "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: Jasper Smith: "Re: Grant Execute to user on procedures"

    Relevant Pages

    • Re: Will Linux become as vulnerable as MS ??
      ... > beeing vulnerable to viruses. ... > that they know are executable, and execute intentionally. ... >> Linux, each distro is a little different, and even within the distro, ... > Since clicking on a script is easier than typing it's name, ...
      (comp.os.linux.security)
    • Re: [Full-Disclosure] ColdFusion cross-site scripting security vulnerability of an error page
      ... > execute the arbitrary javascript and HTML code which the attacker ... > It is possible to display the contents transmitted from the client ... > cross-site scripting attack can be executed. ... the script will be executed when the script for an attack ...
      (Full-Disclosure)
    • CGIscript.net - csMailto.cgi - Remote Command Execution
      ... CGIscript.net - csMailto.cgi - Remote Command ... csMailto is a perl cgi formmail script developed by ... execute command on server and mail output to anyone ...
      (Bugtraq)
    • Re: Extracting data from an XML to put into a constant
      ... ExecuteGlobal "Const cnUB = 9" ... The following script causes the same error. ... Ordinary variables and constants defined with execute statements have ... no value until their defining statement is executed at run time. ...
      (microsoft.public.scripting.vbscript)
    • Re: HTTPContext Session and worker thread (Fire and Forget)
      ... Once the page is loaded on the client side, make the request via script ... To kick of the job you insert record into tblJobs with MessageIn having ... not execute job cause it was grabbed by other pooling thread between step 1 ...
      (microsoft.public.dotnet.framework.aspnet)