Re: View problem

Hey Andreas. It worked GREAT!

Thanks so much!

HAP On Tue, 04 Aug 1998 06:36:23 GMT, andreas.prusch_at_sintec.de wrote:

>As user User1 you have to grant select priviliges to u2 with grant option
>for table T1. (grant select on t1 to u2 with grant option) It seems that the
>database don't test for the owner of the underlying tables of the view.
>
>Hope this will help
>Andreas Prusch
>
>In article <35C620CC.FC1BC522_at_email.exide.com>,
> HAP <proctorh_at_email.exide.com> wrote:
>> I have an interesting situation:
>>
>> The Setup:
>> User1 and User2 are in the same Oracle 7.2.2.3 instance. User1 is in
>> TableSpace1 and User2 is in TableSpace2. U1 owns a table Table1 in TS1,
>> U2 owns a table Table2 in TS2. U1 has "Select Any Table" System
>> proviledge (as well as DBA role). U1 can select against T1 in TS1 and T2
>> in TS2 successfully.
>>
>> The Plot Device:
>> There is a view View1 that is owned by U2 and is in TS2. V1 is a select
>> statement that uses T1 and T2 with an outer join on one column.
>>
>> The Punchline:
>> U2 can select against the view with no problems. U1 cannot select
>> against the view and gets an error (1031 I think) of insufficient
>> proveledges.
>>
>> What gives?
>> Any help you guys can give will be GREATLY appreciated.
>>
>> Thanks!
>> HAP
>>
>>
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Wed Aug 05 1998 - 10:12:11 CDT