This discussion is archived
1 Reply Latest reply: Nov 7, 2013 7:13 PM by scott.wesley RSS

Application alias shows up only when logged in as SYS

tx103108 Newbie
Currently Being Moderated

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?


  • Correct Answers - 10 points
  • Helpful Answers - 5 points