3 Replies Latest reply: Feb 16, 2013 3:58 AM by Denes Kubicek RSS

    Serious security problem on apex.oracle.com

    j4john
      Hi guys,

      I hate to say this, and maybe the post should be in the database forum, but...

      I sign in to apex.oracle.com and open SQL Commands. I run "select * from all_tables where table_name='EMP'" and I get 6 rows returned - mine, and occurrences from 5 other owners.

      The response to "desc emp" is
      report error:
      ORA-01427: single-row subquery returns more than one row

      Never seen anything like it in 20+ years on Oracle.

      Hope it's rapidly rectified, but wonder where else this sort of behaviour may be manifesting...

      JohnD
        • 1. Re: Serious security problem on apex.oracle.com
          fac586
          j4john wrote:
          Hi guys,

          I hate to say this, and maybe the post should be in the database forum, but...

          I sign in to apex.oracle.com and open SQL Commands. I run "select * from all_tables where table_name='EMP'" and I get 6 rows returned - mine, and occurrences from 5 other owners.

          The response to "desc emp" is
          report error:
          ORA-01427: single-row subquery returns more than one row

          Never seen anything like it in 20+ years on Oracle.
          Really? In 20 years you've never seen:
          grant select on emp to public;
          ???
          • 2. Re: Serious security problem on apex.oracle.com
            j4john
            Doh! It's my meds...
            • 3. Re: Serious security problem on apex.oracle.com
              Denes Kubicek
              Don't worry. The same thing happens to me from time to time. The first doubt that comes to my mind is that if my assumption would be true then for sure I wouldn't be the first one to notice it :). After that I do another loop just to make sure.

              Denes Kubicek
              -------------------------------------------------------------------
              http://deneskubicek.blogspot.com/
              http://www.apress.com/9781430235125
              http://apex.oracle.com/pls/apex/f?p=31517:1
              http://www.amazon.de/Oracle-APEX-XE-Praxis/dp/3826655494
              -------------------------------------------------------------------