Re: Create or Replace View

From: Randy Harris <randy_at_SpamFree.com>
Date: Fri, 02 Jul 2004 06:01:55 GMT
Message-ID: <nT6Fc.112$m%7.67@newssvr19.news.prodigy.com>

"Sybrand Bakker" <sybrandb_at_hccnet.nl> wrote in message news:ouq9e016co1keqmc8drd68nhrhr849arf0_at_4ax.com...
> On Fri, 02 Jul 2004 00:11:27 GMT, "Randy Harris" <randy_at_SpamFree.com>
> wrote:
>
> >Is there any way to create a view based on a table in another schema? I
can
> >select from lms_data.class, but:
> >
> >Create View testview as
> >Select * from lms_data.class;
> >
> >returns an error, table class not found. I tried using a synonym and got
> >the same result.
> >
> >Thanks for any help.
> >
> >
> >
>
> You need *direct* privilege to the lms_data.class table as opposed to
> privileged through a role.

Ahhh. Thank you very much.

> --
> Sybrand Bakker, Senior Oracle DBA
Received on Fri Jul 02 2004 - 01:01:55 CDT