Re: Create or Replace View

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.

--
Sybrand Bakker, Senior Oracle DBA