3.5 About APEX Database Accounts

Oracle APEX creates the following database accounts at installation.

  • APEX_240200 - This schema-only account owns the APEX platform schema and metadata. This account is always locked.
  • FLOWS_FILES - This schema-only account owns the APEX-uploaded files that are not stored in workspace schemas. This account is always locked.
  • APEX_PUBLIC_USER - This minimally privileged account is used for APEX configuration with Oracle REST Data Services.
  • APEX_PUBLIC_ROUTER - This minimally privileged account is used for an ORDS REST module to resolve friendly URLs.

If you configured RESTful Web services, APEX also creates the following additional accounts:

  • APEX_REST_PUBLIC_USER - This account is used when invoking RESTful Services definitions stored in APEX.
  • APEX_LISTENER - This account is used to query RESTful Services definitions stored in APEX.

If you are upgrading from a previous release, all of the above accounts may already exist except APEX_240200.