Re: Can't create stored procedure to refer to table in other scheme.
From: Peter Cohen <peter.m.cohen_at_saic.com>
Date: Fri, 4 May 2001 16:55:22 -0400
Message-ID: <9cv51t$dsk$1_at_bob.news.rcn.net>
Date: Fri, 4 May 2001 16:55:22 -0400
Message-ID: <9cv51t$dsk$1_at_bob.news.rcn.net>
First give the schema owner privileges (select, insert, update, delete, etc) to the table in schema "B". Then, create a public synonym for the table in question. Your stored procedure should reference the table fine after that.
"Larry Lau" <llau_at_techtier.ca> wrote in message
news:LoOE6.7940$SI5.1560075_at_news1.telusplanet.net...
> Anyone know why?
>
> Larry,
>
>
>
Received on Fri May 04 2001 - 22:55:22 CEST