1 Reply Latest reply: Nov 7, 2013 9:13 PM by scott.wesley RSS

    Application alias shows up only when logged in as SYS

    tx103108

      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?