I have a schema called SCHEMA1 with packages and tables that needs to be accessed by user SCHEMA2.
I want SCHEMA2 to have access for executing packages and look at source code. Also I would like to give SELECT access to all tables for SCHEMA2.
How can I do that? Thank you.