Re: Configuring users

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: AnthonyThomas (Anthony.Thomas_at_CommerceBank.com)
Date: 12/20/04 

Date: Mon, 20 Dec 2004 07:39:06 -0600

Or db_ddladmin; however, this will also give them edit permissions on all
objects in the database.

Sincerely,

Anthony Thomas 

-- 
"Wayne Snyder" <wayne.nospam.snyder@mariner-usa.com> wrote in message
news:eIaw0Jp5EHA.1408@TK2MSFTNGP10.phx.gbl...
Currently only the owner, the DB owner or someone with system administration
permissions can alter an sp...
-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tom Swanick" <tom.swanick@activant.com> wrote in message
news:OFRuinn5EHA.2876@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I am connecting to sql server 2000 from an Access 2000 project. I want to
> have  certain users edit a stored procedure. I can give them execute
> permission but this doesn't allow them edit. I don't want to give them
owner
> permissions on the sp.
>
> How do I allow them edit this sp only?
>
> Thanks
>
> Tom
>
>

Relevant Pages

  • Re: Configuring users
    ... Currently only the owner, the DB owner or someone with system administration ... permissions can alter an sp... ... Wayne Snyder, MCDBA, SQL Server MVP ... > permission but this doesn't allow them edit. ...
    (microsoft.public.sqlserver.server)
  • RE: SQL 2005 Management Studio cant edit text rows with > 4000 ch
    ... in SSMS, I cannot do the same thing. ... a text field, if I edit the int field, it fails. ... In SQL Server no matter 2000 or 2005, the default maximum size that can be ... table name','text in row',7000", the text-type field can support maximum ...
    (microsoft.public.sqlserver.tools)
  • Re: edit/delete items in a list w/o granting Manage Area
    ... >and provide these essential permissions ... > Edit Items - Edit items in lists, ... >in that when a user publishes a listing to an area, ... To give them the ability to ...
    (microsoft.public.sharepoint.portalserver)
  • ADP, Application Role, and objects
    ... The above link is to an atricle on how to implement SQL Server Application ... After you connect with your ADP, fire a bit of code to set the ... third party tools to view the data on the same database. ... Scenario 1 - If I explicitly grant permissions on that object to the user ...
    (microsoft.public.access.adp.sqlserver)
  • RE: Error 1030/1058 in EventViewer + "Access is Denied" trying to edit GPOs
    ... 1> What is the account you used to log in the server to edit the Group ... 2> Check the permissions settings in ADSI Edit. ... Newsgroup for us to better understand your issue. ... Download and run Filemon tools. ...
    (microsoft.public.windows.server.sbs)