EXECUTE on SYS.UTL_MAIL in a 12.2.0.1 PDB
Hi
I have a 12.2.0.1 CDB. I have created sys.utl_mail package in the CDB signed on as SYS. when I query DBA_OBJECTS with container as CDB$ROOT, I see the package, Package Body and Public Synonym listed.
Then I had plugged in a PDB ( this migrated from another CDB in the same server) and when I run the same select after setting container to the PDB, the SYS.UTL_MAIL does not show up.
When I try to grant execute on SYS.UTL_MAIL to a local user, that throws an error that the program does not exits.