ORA-20987 Error When Using APEX_UTIL.create_user In APEX5
(Doc ID 2210311.1)
Last updated on FEBRUARY 18, 2021
Applies to:Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Application Express (APEX) - Version 5.0.4.00.12 and later
Information in this document applies to any platform.
On 5.0.4.00.12 version, Administration
When attempting to use APEX_UTIL.create_user that changes apex users (like reset pwd) the following error occurs:
ORA-20987: APEX - User requires ADMIN privilege to perform this operation. - Contact your application administrator.
The issue can be reproduced with the following steps:
- From APEX GUI sql*workshop execute something like:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
Symptoms Changes Cause Solution
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.