'Can't select the package body from other schema in Oracle 10.2.0.4

My user has the following privileges:

`GRANT CREATE SESSION to user1;
GRANT SELECT ANY TABLE to user1;
GRANT SELECT_CATALOG_ROLE to user1;
GRANT SELECT ANY DICTIONARY to user1;
GRANT SELECT ANY SEQUENCE to user1;
GRANT EXECUTE ANY TYPE to user1;
GRANT ALTER SESSION to user1;`

I can't get the package body runnig the following query from user1:

    SELECT owner, name, text, line FROM sys.DBA_source WHERE type='PACKAGE BODY'         
         AND owner NOT IN ('SYS')   AND owner = 'USER2'  AND name = 'MY_PKG'    

But when I run a query from another user who has all the privileges, I can get the package body.

This issue was reproduced only on one server (Oracle 10.2.0.4).

Tell me please what privileges are missing. Or if it's not about privileges, tell me what to do to make it work.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source