Re: Rights to change an SP

From: Patricia (pat777@hotmail.com)
Date: 06/25/02 

From: "Patricia" <pat777@hotmail.com>
Date: Tue, 25 Jun 2002 16:07:55 +0200

Thanks for the idea. What do you mean by "ownership chain issues"?

"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:9fsghu0ktj4thtko5i7fp4ckst5uccdp0i@4ax.com...
> The only way I can think of is to make the user the owner of
> those stored procedures but then you will likely be dealing
> with ownership chain issues. There isn't any direct way to
> grant just alter procedure permissions or to do so on just a
> few procedures.
>
> -Sue
>
> On Tue, 25 Jun 2002 10:36:31 +0200, "Patricia"
> <pat777@hotmail.com> wrote:
>
> >I'd like to give a user the rights to change the code a several specific
> >SPs.
> >However I don't want to make him an owner of the database.
> >
> >Is there a way to do that?
> >
> >Thanks
> >
>

Relevant Pages

  • Re: Permission Denied executing SP that reads foreign table!
    ... > When a stored procedure is executed the user calling the SP may not have ... not checked as long as the objects involved have the same owner. ... the ownership chain, it is the login associated with the object owner. ... Since the login mapping for the 'dbo' user is determined by database ...
    (microsoft.public.sqlserver.security)
  • Re: Controlling create & drop proc, view privilege
    ... > roles to create a objects owned by dbo. ... It depends first on ownership the ownership chain. ... > permissions to execute the stored procedure only. ... > branch where the owner of the object is different. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server Permission Question
    ... If they both have the same owner, a technique named ownership chain ... that if they have access to the stored procedure ...
    (microsoft.public.sqlserver.security)
  • Re: Rights to change an SP
    ... those stored procedures but then you will likely be dealing ... with ownership chain issues. ... >However I don't want to make him an owner of the database. ...
    (microsoft.public.sqlserver.security)
  • Re: High strength fibers for high pressure tubes.
    ... ***{In such a case, properly, there is no one to sue. ... will be sufficient to indicate denial of permission by the owner ... > Doesn't matter unless I signed away some of my rights when I moved in. ... neutral arbiter, rather than point a gun at you and take the wallet by ...
    (sci.physics)