I'm using Oracle 11gR2 XE. A user with dba privileges can't log in to the APEX interface, but can from the command line with sqlplus.

I just created user:

CREATE ROLE administrators;
GRANT dba TO administrators;
GRANT administrators TO superuser;

If I run cmd, type sqlplus and log in with "superuser", I get access.

But the web interface (APEX) denies access with an "invalid credentials" error message.

What do I need to do to be able to log in on the APEX interface?

1 Answer 1


The APEX administrator accounts are not linked to a database schema. Reciprocally, creating a database schema won't create an APEX account.

You'll have to create the administrator account via the web interface.

  1. Connect to the administration page:

    • If your setup uses the embedded PL/SQL gateway, go to:

    • If your setup uses Apache and mod_plsql, go to:


    Then On the Login page:

    • In Username, enter admin.

    • In Password, enter the Oracle Application Express administrator account password you specified when you installed Oracle Application Express.

  2. There are three levels of administration, decide which type you want to create:

    • Developers create and edit applications.

    • Workspace administrators are developers who also perform administrator tasks specific to their workspace such as managing user accounts, monitoring workspace activity, and viewing log files. See "Workspace and Application Administration".

    • Oracle Application Express administrators are superusers that manage the entire hosted instance using the Oracle Application Express Administration Services application.

I suppose you want to create an APEX administrator account. They are workspace administrator of the special workspace "Administration" that you can create following the standard APEX account creation.

  • So Apex users are different from db system users (ones logging by sqlplus)?
    – dbadmin
    Commented May 12, 2013 at 13:03
  • Apex users and database schemas (users) are totally disjoint. Commented May 13, 2013 at 8:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.