RE: Oracle bug or I miss something

From: Sinardy Xing <SinardyXing_at_bkgcomsvc.com>
Date: Thu, 2 Dec 2004 01:31:42 +0800
Message-ID: <7534CC34CD1D9F49BB05A00B9C6F20F401853087@antares.bcsgroup.com.sg>

yes same user, by the way I just leave it with dba_sequences for the = moment

I find no problem with all_triggers and all_synonyms

1:30 am already I want to go home, thanks all I am very tired....

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of David Sharples Sent: Thursday, December 02, 2004 1:10 AM To: oracle-l_at_freelists.org
Subject: Re: Oracle bug or I miss something

are they run as the same user - if you dont have select privelege on the seuqnce then you wont see it in all_sequences

On Thu, 2 Dec 2004 00:59:11 +0800, Sinardy Xing=20 oracle-l_at_freelists.org

> Select count(*) from all_sequences=3D20

>=20

> return 0

>=20

> Select count(*) from dba_sequences=3D20
>=20
> return correct # of sequence

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

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

Received on Wed Dec 01 2004 - 11:30:18 CST