Re: access to create stored procs

From: Stockton P. (stocktonpetri@hotmail.com)
Date: 12/30/02 

From: "Stockton P." <stocktonpetri@hotmail.com>
Date: Mon, 30 Dec 2002 13:06:56 -0600

I found the solution in BOL.

GRANT CREATE PROCEDURE to username

"Stockton P." <stocktonpetri@hotmail.com> wrote in message
news:OboF4SDsCHA.856@TK2MSFTNGP12...
> How do I grant a user the right to create stored procs that read and write
> data,
> but NOT allow this user to issue DDL commands (create,modify tables)?
>
> Thanks
>
>

Relevant Pages

  • Re: Adding users
    ... Not only does AUTHORIZE not show it, new processes did not get the right ... When I grant the id I get the GRANTMSG returned, but SHOW USERNAME does ... A second grant gives me a GRANTERR ...
    (comp.os.vms)
  • Re: Group policy software install & directory access rights
    ... Grant "Authenticated Users" read/execute access. ... > the install files if it does not have a username and password? ... > So I log into the local workstation as the local admin which is not a ... > So I'm thinking that the reason my GPO install is failing is because the ...
    (microsoft.public.windows.server.active_directory)
  • Re: Logon failed for user ". but only for membership tables in same database that other request wor
    ... OK to login SQL Server on Computer B. ... I would like you to do a test that on ComputerB, log on using the Username ... You may use the GRANT statement to grant the EXECUTE permission for a user: ... GRANT System Object Permissions (Transact-SQL) ...
    (microsoft.public.sqlserver.security)
  • RE: ERROR 1045: Access denied for user:
    ... When you select user from users what does the username say? ... mysql> GRANT ALL PRIVILEGES ON *.* TO 'mikesd'@'localhost' ... unsubscribe mailto:redhat-list-request@redhat.com?subject=unsubscribe ...
    (RedHat)
  • Re: Table permissions
    ... This script was written by Aaron Bertrand ... been explicitly given access to the procs using GRANT. ... SELECT @username = '???' ...
    (microsoft.public.sqlserver.programming)