1 Reply Latest reply: Nov 7, 2013 9:13 PM by swesley_perth RSS

    Application alias shows up only when logged in as SYS


      Oracle 11gR2

      APEX 4.2.3

      RHEL 6.3



      select *
      from   apex_applications
      where  workspace = 'MY_WORKSPACE';


      -- 0 rows


      When logged into APEX as a user with a workspace assigned (MY_WORKSPACE) that contains an application (and an application alias), no rows are returned when given the application alias in the query above (see the above SQL).

      But log in as SYS and the application alias is there -- i.e. a row is returned.

      What could be causing this?