View problem

From: HAP <proctorh_at_email.exide.com>
Date: Mon, 03 Aug 1998 16:42:52 -0400
Message-ID: <35C620CC.FC1BC522@email.exide.com>

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 Received on Mon Aug 03 1998 - 15:42:52 CDT