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!

Oracle APEX returns error when I try to create user from the outside of APEX

c1922f8b-98f7-49b9-9f49-fed080cb01b8May 20 2019 — edited May 22 2019

My app in Oracle APEX is a part of the bigger project made in a few frameworks. By years, users and all of they properties was set on another application in Oracle Forms. When I was using Oracle APEX 4, everything was working, but now I have to migrate to 18.2.0.00.12 and here is the point.

Patient: App in Oracle APEX 18.2.0.00.12

Issue: when I try to create user using procedure "apex_util.create_user" I got error:

APEX - User ADMIN11 requires ADMIN privilege to perform this operation. - Contact your application administrator.

When I go for Manage Users -> ADMIN11 -> Account Privileges I see here:

admin11.JPG

When I try to use this procedure in SQL Developer I got the same error...

What else I have to set or change to let users create new users? I need to create users outside of apex - just in PL/SQL. I found some informations that developers made some undocummented changes in security, in APEX 4 everything works. This is the only thing which's blocking my app migration to APEX 18.

Comments
Post Details
Added on May 20 2019
2 comments
851 views