PL/SQL - Cursor question

I am logged on as userID: OWNER1 (with dba privelege)

When Declaring a cursor in a new procedure, I get the following error: (note: the cursor is on a table owned by another userID)

cursor MyCursor is
select * from OWNER2.table1;

PLS-00201: identifier 'OWNER2.TABLE1' must be declared

is this possible to do?? can you only declare cursors on tables you own??

Thanks Received on Thu Dec 20 2001 - 13:26:34 CET