Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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;
CREATE USER superuser IDENTIFIED BY "root";
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?

share|improve this question
add comment

1 Answer

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:

      http://hostname:port/apex/apex_admin
      
    • If your setup uses Apache and mod_plsql, go to:

      http://hostname:port/pls/apex/apex_admin
      

    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.

share|improve this answer
    
So Apex users are different from db system users (ones logging by sqlplus)? –  dbadmin May 12 '13 at 13:03
    
Apex users and database schemas (users) are totally disjoint. –  Vincent Malgrat May 13 '13 at 8:01
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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