Re: access to create stored procs

From: Beth Breidenbach (beth.breidenbach@getronics.com)
Date: 12/30/02 

From: "Beth Breidenbach" <beth.breidenbach@getronics.com>
Date: Mon, 30 Dec 2002 11:16:25 -0800

In query analyzer,

"grant create procedure to loginname"

If the user only has dataread and datawrite roles to start with, all you'll
have added is the ability to manage procedures.

See grant, deny, revoke in BooksOnline for more details.

Beth

"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

  • Granting specific access for an OWA user
    ... I would like to grant the ability to change the message properties. ... I see some permissions that look like they ...
    (microsoft.public.exchange2000.active.directory.integration)
  • Re: Technical insecurity: A virtue?
    ... Yet the issue isn't the ability to judge, ... we grant that one is able to judge. ... entitlement or ability, but conformity to reality. ...
    (rec.music.classical.guitar)
  • How do I delegate use of .msc?
    ... I want to grant a group of users the ability to create new file shares ... custom msc that just has the "Shared Folders" snap-in. ...
    (microsoft.public.win2000.active_directory)
  • grant reset password ability to user
    ... How do I grant a user the ability to be able to reset passwords for other ... Prev by Date: ...
    (microsoft.public.windows.server.active_directory)
  • Re: Alternative to the Mighty Mouse?
    ... Two google clicks got me: ... which shows how to dismantle it. ... Fiddly I grant you, but the ability to scroll in two directions without ...
    (uk.comp.sys.mac)