"al" <news@thispartisfake-13c.com> wrote in message news:%23oss5b2SDHA.2196@TK2MSFTNGP12.phx.gbl...
> I have some tables with the same name but owned by different users. I have
> some UDFs that return a table variable. The SELECT statements in the UDF
> cannot 'see' the non dbo tables. The Same SELECT does work outside of the
> UDF. In the SELECT statement there is no owner prefix. If I prefix it to the
> specific user it works , but that won't do because I want the table the user
> owns to be returned, I cannot specify the owner.
>
> Is this a Bug?
>
> al
>
>

"Dean Savovic" <dsavovic@inet.hr> wrote in message
news:bf5hcc$2mp$1@brown.net4u.hr...
> It seems to me that you have broken chain of ownership.
>
> --
> Dean Savovic
> www.teched.hr
>
>
> "al" <news@thispartisfake-13c.com> wrote in message
news:%23oss5b2SDHA.2196@TK2MSFTNGP12.phx.gbl...
> > I have some tables with the same name but owned by different users. I
have
> > some UDFs that return a table variable. The SELECT statements in the UDF
> > cannot 'see' the non dbo tables. The Same SELECT does work outside of
the
> > UDF. In the SELECT statement there is no owner prefix. If I prefix it to
the
> > specific user it works , but that won't do because I want the table the
user
> > owns to be returned, I cannot specify the owner.
> >
> > Is this a Bug?
> >
> > al
> >
> >
>
>