Oracle Application Express (MOSC)

MOSC Banner

Why is the a user created using APEX_UTIL.CREATE_USER is not appearing in APEX Workspace?

APEX version: 20.1

I am developing a procedure to programmatically create an End User by using the APEX_UTIL.CREATE_USER procedure.

I have written a pretty standard procedure to create the user and the PL/SQL code was executed successfully in SQL Developer. I am logged in as the APEX default schema.

When I queried the APEX_WORKSPACE_APEX_USERS view as the default schema user, I can see the user I just created in the view. However, when I logged into the APEX Workspace as the same user and go to Manage User and Groups, the new user is not there.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center