Re: Creating Views joining tables in two different schemas

That was it!. I didn't grant select on the table. Once that was done, the view was created and works perfectly.

Thanks,
Ed

On Fri, 09 Jun 2000 07:44:43 GMT, michael_bialik_at_my-deja.com wrote:

>What errors?
>
> If error messages are security related - try GRANT SELECT to other
> schema table directly to view owner ( not through role ).
>
> HTH. Michael.
>
>
>In article <FoBAOd9iUxA+6a=93q7Z3vSZVd5z_at_4ax.com>,
> Ed Ziegler <eziegler_at_nextphase.com> wrote:
>> I've tried to create a view using a query joining tables in the
>> current schema and a different schema. The query statement itself
>> works when run interactively with SQLPlus, but creating the view
>> errors when I try to create the view.
>>
>> The query is like:
>>
>> SELECT A.FIRST, B.SOMETHING
>> FROM LOCAL_TABLE A, OTHER_SCHEMA.TABLE B
>> WHERE A.KEY = B.KEY;
>>
>> The query returns values when run. But when I try to create a view as
>> 'CREATE VIEW foo AS SELECT ...' the statement errors out and the view
>> is not created.
>>
>> Perhaps I'm trying to do something that isn't permitted in Oracle, but
>> if anyone knows a solution or where I'm going wrong I would appreciate
>> some help.
>>
>> Thanks,
>>
>> Ed
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Jun 09 2000 - 00:00:00 CDT