Thanks for taking my question!
I just updated my database from 11.2 to 12.1.0.2 (on windows). I followed the Oracle recommendation and created an "oracle home user" to secure the oracle services. The oracle documentations states in bold letters to make sure the new "oracle home user" isn't in the admin group. It doesn't say why but my guess is because it less secure.
After the upgrade, all jobs using utl_mail get a "access is denied" error when they are started by the oracle job scheduler. If I run the same job as a procedure using TOAD, the job completes just find and UTL_Mail works.
To fix the problem, I change the oracle job schedule (window service) to use the "Local User" instead of the "oracle home user". The Oracle listener and the database services are still running under "Oracle Home User".
My question is: Is there a better way to handle this situation? Am I setting myself up for future issues next time I try to upgrade?
Thanks!
Kathie