Re: Configuring users

From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 12/20/04 

Date: Mon, 20 Dec 2004 07:49:13 -0500

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: impossible for other user to chmod files?
    ... > and edit text files (members, of course, will not have normal sign-on FTP ... > hitting a real problem with file and directory permissions, ... > writes only for the 'owner' of that file. ... > (allow general users of my site to manage their own little webspace), ...
    (comp.lang.php)
  • Re: Configuring users
    ... the DB owner or someone with system administration permissions can alter an sp... ... Wayne Snyder, MCDBA, SQL Server MVP ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ... I want to> have certain users edit a stored procedure. ...
    (microsoft.public.sqlserver.server)
  • [kde-linux] Address book locked
    ... When I try to add or edit an address book entry it get ... permissions and both that file and "addressbook.vcf" are can read & write by ... owner. ...
    (KDE)
  • Re: Default permissions for schema owner
    ... In SQL Server 2005, you can use the Has_Perms_By_Namefunction ... Can someone please list down the set of default permissions that the ... owner of a schema gets by default? ... Atleast the very basic and ...
    (microsoft.public.sqlserver.security)
  • Re: Permissions
    ... Do the objects have the same owner ... I have a table, myTable, in a schema named Schema1. ... The permissions on Schema1.myTable are left unchanged (no ... This is Sql Server 2005 Standard, ...
    (microsoft.public.sqlserver.server)