Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

apex_acl.has_user_any_roles returning FALSE for every user that has a role

renansgOct 29 2024

Hello There

I am facing some issues trying to execute the sample app that sends e-mail for verification code. I've done all settings that is needed to send some e-mail and i can send e-mail when i try by code directly in PL/SQL.

I was debugging the sample app, and the problem is this function APEX_ACL.HAS_USER_ANY_ROLES (HAS_USER_ANY_ROLES Function)

Before trying to send some e-mail that function is executed to verify if the user has any roles, but i tried to execute this function in a PL/SQL block and every user and app just returns FALSE even users that has roles in the table APEX_APPL_ACL_USER_ROLES.

I can't verify the code of APEX_ACL.HAS_USER_ANY_ROLES, APEX_ACL is a Synonym that relates to WWW_FLOW_ACL_API that i can't see the body (it's like encrypted code).

What should I do to make this function return TRUE?

Print's Bellow

Snap 2024-10-29 at 14.31.13.png

Snap 2024-10-29 at 14.29.06.png

Snap 2024-10-29 at 14.28.04.png

Comments
Post Details
Added on Oct 29 2024
4 comments
65 views