My Oracle Support Banner

ORA-20987 Error When Using APEX_UTIL.create_user In APEX5 (Doc ID 2210311.1)

Last updated on MARCH 01, 2023

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.

Symptoms

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:

ERROR
-----------------------
ORA-20987: APEX - User requires ADMIN privilege to perform this operation. - Contact your application administrator.

STEPS
-----------------------
The issue can be reproduced with the following steps:

  1. From APEX GUI sql*workshop execute something like:

     

    Changes

     

    Cause

    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.