Re: Functions

From: Andrew J. Kelly (akelly@targitinteractive.com)
Date: 07/15/02 

From: "Andrew J. Kelly" <akelly@targitinteractive.com>
Date: Mon, 15 Jul 2002 10:13:38 -0400

No that is a requirement of a UDF, there is no way around it. You should
always qualify your objects with the owner anyway, even sp's. By qualifying
the object it is more likely to use a cached plan and is more efficient
overall behind the scenes. 

--
Andrew J. Kelly   SQL MVP
Targitinteractive, Inc.
"Sumesh" <Sumesh.Sundareswaran@trsga.com> wrote in message
news:1889e01c22c06$15436740$19ef2ecf@tkmsftngxa01...
> Everyone,
>
> I have compiled some common functions into dbo, which the
> development team wants access to. After compiling the
> functions under dbo, I gave execute rights for all the
> functions to the developers. The problem is that when the
> developers access it, they have to put the dbo qualifier
> in front of the function they need to access. For eg. In
> order to run function a, they have to qualify it by dbo.a.
> Is there a way I can just just get them to run the
> function without the qualifier, as we do with stored
> procedures?
>
> Thanks,

Relevant Pages

  • Functions
    ... I have compiled some common functions into dbo, ... After compiling the ... developers access it, they have to put the dbo qualifier ...
    (microsoft.public.sqlserver.security)
  • Re: Who owns the tables in development environment? (upsizing from Access)
    ... qualify the owner as dbo when doing Access upsizing. ...
    (microsoft.public.sqlserver.clients)
  • Re: object reference in stoed proc
    ... If you don't qualify the object sql server will first look for the object ... as such it will eventually try dbo. ... implications by not qualifying the objects with the owner. ... all object refences dbo by default anyway within a stored procedure? ...
    (microsoft.public.sqlserver.security)
  • Re: Can run sp as Administrator but not as User/dbo
    ... ddladmin and db_owner need to qualify the ... table name for it to be owned by dbo. ... If you need the user to be able to execute DDL statements as ... >BTW I changed user from dbo to ddladmin role which seems OK.. ...
    (microsoft.public.sqlserver.security)
  • Re: defaulting newly created objects to DBO
    ... backwards compatibility only. ... Members of db_owner should qualify the objects they are ... creating with dbo. ...
    (microsoft.public.sqlserver.security)
Quantcast