Hi.
I'm guessing you will probably need to make sure APEX_050000 (or different
number depending on version) has the ACL against it.
If I am honest, I just keep adding users until it works, then I drop and
recreate the ACL with just the ones needed. :)
Cheers
Tim...
On Tue, Nov 8, 2016 at 1:31 PM, Mark J. Bobak <mark@xxxxxxxxx> wrote:
Hello Oracle-L ers,
I'm struggling to get UTL_SMTP functionality to work from APEX.
I think my biggest confusion is around APEX, and which DB user is
connecting to the database.
Before I proceed:
Oracle 12.1.0.2
Apex 5.0.3
ORDS 3.0.4
Glassfish 4.1.1
User logs into APEX app, goes to form, fills out form, clicks submt, and
mail sending encounters ORA-24247.
I've done the ACL create and assign before, and gotten it to work.
My question is, what user is APEX connecting as? APEX_PUBLIC_USER?
ORDS_REST_PUBLIC_USER? ANONYMOUS? Something else?
Help!
Thanks,
-Mark