Re: PL/SQL - Cursor question

billiauk wrote:
>
> If you have DBA role, then you should be able to "SELECT ANY TABLE",
> which means you can create a cursor over another schema's tables...
>
> You might want to investigate your "DBA privileges"...........
>
> Adrian

Nope - DBA is a role, and roles are not active during the execution of packages. So, you'll need:
either access to that table
 (OWNER2> grant select on table1 to owner1;) or have select any table granted directly  (OWNER1> grant select any table to owner1;)

You might want to investigate roles and object priveleges

-- 
Gtrz,

Frank van Bortel