Configuring users

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
TomCurrently 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
>|||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
>