Skip to Main Content

APEX

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Apex 21.1.5 - apex_util.create_user requires ADMIN privilege

JeanYves BernierJan 10 2022

Hi there,
We have an app that allows some power users to create others end users
We have rewritten the application in apex 21.1.5 (the previous one was in apex 4)
To create the users, we have a procedure that wraps apex_util.create_user.
But this returns ORA-20001: User requires ADMIN privilege.
We cannot make these power users as workspace admin.
I saw a workaround : grant apex_administrator_role to apex_public_user;
Don't know if this the best way for addressing this issue ?
Does anyone have a solution for that ?

Regards
JeanYves

This post has been answered by fac586 on Jan 11 2022
Jump to Answer
Comments
Post Details
Added on Jan 10 2022
11 comments
924 views