Re: PL/SQL - Cursor question

Asas <jjj_at_jjj.com> wrote in message news:<o7m32uss3dgmoieseh5u8jerj9ank1svjo_at_4ax.com>...
> 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

hi asas
yes you have got it right
you can only create cursors on tables which you own or on those tables on which either you have DML privilages or select privilage Received on Fri Dec 21 2001 - 06:55:38 CET