[Oracle] Permissão para View Package / Package Body Oracle 10g

CREATE ROLE RL_PACKAGE NOT IDENTIFIED;

CREATE USER USER_PACKAGE PROFILE DEFAULT
IDENTIFIED BY USER_PACKAGE DEFAULT TABLESPACE DEFUALT
TEMPORARY TABLESPACE TEMP
ACCOUNT UNLOCK;
GRANT CREATE SESSION TO USER_PACKAGE;
GRANT SELECT ANY DICTIONARY TO USER_PACKAGE;
GRANT RL_PACKAGE TO USER_PACKAGE;

SELECT ‘GRANT ‘ || DECODE(OBJECT_TYPE, ‘PACKAGE’, ‘EXECUTE’, ‘FUNCTION’, ‘EXECUTE’) ||
‘ ON ‘ || OBJECT_NAME || ‘ TO RL_PACKAGE;’
FROM USER_OBJECTS
WHERE OBJECT_TYPE IN (‘PACKAGE’, ‘FUNCTION’);

PL/SQL Developer: Tools –> Preferences –> Oracle –> Options –> Use DBA Views if available
TOAD: View -> Options -> Startup , and checked “Check for Access to DBA Views”