Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: View problem
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 Tue Aug 04 1998 - 01:36:23 CDT