Oracle Database Jobs

Hi I'm using Oracle 19c database. I created a new user/schema called MM_UAT and given the required grants. I want the MM_UAT user only to see the DB_OBJECTS of other schemas or specific schema. My required DB_OBJECTS like tables, views, functions and procedures seems OK. but there's a problem. If I right click and open a package like PRODN.PKG_REPORTS and i click "view spec & body", i cannot see the body i see only the specs. I have given extra permissions as well to check if they work: GRANT EXECUTE ANY PROCEDURE TO MM_UAT; GRANT DEBUG CONNECT SESSION TO MM_UAT; GRANT SELECT ANY DICTIONARY TO MM_UAT; GRANT SELECT_CATALOG_ROLE TO MM_UAT; GRANT SELECT ON DBA_SOURCE TO MM_UAT; GRANT EXECUTE ON PRODN.PKG_REPORTS TO MM_UAT; CREATE OR REPLACE VIEW SYS.PRODN_PKG_BODY...

Project Overview: We are seeking skilled professionals to migrate our existing Hospital Information System (HIS) application developed in Oracle Forms and Oracle Reports to a modern, web-based architecture using Oracle APEX and BI Publisher. The current application serves as a critical system for managing hospital operations, including patient management, billing, inventory, HR, and more. The project involves converting all functionality, workflows, and reports while ensuring high performance, usability, and scalability. The target system should maintain data integrity, provide responsive design for access across devices, and include enhanced security measures. ________________________________________ Project Scope: 1. Application Conversion: o Convert all Oracle Forms modules to Oracle AP...