Grant privileges for an Oracle package? Grant privileges for an Oracle package? oracle oracle

Grant privileges for an Oracle package?


Use GRANT to give execute privileges

grant execute on PACKAGE_B to new_schema;

Then, you need to ensure that any reference in package A includes the full path:

PACKAGE_B.SOME_PROC

It might be worth creating a public synonym in for the package, so that you can avoid referencing the schema too.