Recent content by ptbarnum

Thanks for the response. SQL*Plus gives a message that the package compiled with errors. In the meantime we found a quote in a PL/SQL manual that says a user needs to be granted rights to all tables referenced in a package directly, not through a role, to be able to compile a package. Can you...

When we use roles to grant access from one schema to another using a role to grant select access to a group of tables verses assigning each schema the select rights, we are unable to compile a package from within the Package editor. If I cut and paste the script from the package editor to a...