Re: Oracle APEX help!

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_at_bobak.net> 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
>

--
http://www.freelists.org/webpage/oracle-l