RE: Strange output

From: Mercadante, Thomas F (LABOR) <>
Date: Tue, 29 Apr 2008 15:38:03 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF01C49CA2@EXCNYSM0A1AJ.nysemail.nyenet>


Might you have two versions of this table someplace?

Connect as sys

Select owner, table_name
From dba_tables
Where table_name = 'FAMIS_GURFEED';

Select * from dba_synonyms
Where synonym_name = 'FAMIS_GURFEED';

As a last resort, are you using Fine Grained Access control on this table to limit the result of queries for some reason?


-----Original Message-----

[] On Behalf Of Mir M. Mirhashimali Sent: Tuesday, April 29, 2008 2:42 PM
Subject: Strange output

Database is Redhat Linux 64-bit.

any idea what may cause this. When logged in as the schema owner i don't see all rows. but when i login as system i see all rows.

$ sqlplus /nolog

SQL*Plus: Release - Production on Tue Apr 29 13:34:00 2008 SQL> connect famis
Enter password:
SQL> select count(*) from famis_gurfeed;



SQL> connect system
Enter password:
SQL> select count(*) from famis.famis_gurfeed;





-- Received on Tue Apr 29 2008 - 14:38:03 CDT

Original text of this message