RE: Strange output

From: "Seema Ahuja" <sahuja@xxxxxxxxxxxx>
To: "mhyder@xxxxxxxx" <mhyder@xxxxxxxx>
Date: Tue, 29 Apr 2008 12:49:08 -0700

When you ran the last two queries, whom were you connected as?

-Seema  


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Mir M. Mirhashimali
Sent: Tuesday, April 29, 2008 12:42 PM
To: Dennis Williams
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Strange output

SQL> select owner, object_name, object_type  from dba_objects where
object_name = 'FAMIS_GURFEED';

OWNER                          OBJECT_NAME                    OBJECT_TYPE
------------------------------ ------------------------------
-------------------
PUBLIC                         FAMIS_GURFEED                  SYNONYM
FAMIS                          FAMIS_GURFEED                  TABLE
RICE_FAMIS                     FAMIS_GURFEED                  TABLE

there is a public synonym. but executing the select with schema owner
padded display the same result.

SQL> SELECT COUNT(*) FROM famis.FAMIS_GURFEED;

  COUNT(*)
----------
      5022

--
Mir


Dennis Williams wrote:
> Mir,
>
> You might check some possibilities like synonyms, views, etc. Are
> there two tables with that name?
>
> Dennis Williams
> !DSPAM:59,481774b6323196954814159!
--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l

References:

New form of sql injection hack documented
From: Adams, Matthew (GE Indust, ConsInd)

Re: New form of sql injection hack documented
From: rjamya

Strange output
From: Mir M. Mirhashimali

Re: Strange output
From: Dennis Williams

Re: Strange output
From: Mir M. Mirhashimali

RE: Strange output

Other related posts: