Re: 8.1.5/HP-UX 11/all_objects view

Kirti, thanks for the clarification.

joe
"Deshpande, Kirti" wrote:
>
> Joe/Mike:
> If the synonyms are PUBLIC they will appear in ALL_OBJECTS and ALL_SYNONYMS.
>
> If these are PRIVATE synonyms, they will not appear in ALL_OBJECTS, even if
> the user has access to the table.
>
> With access to the table PRIVATE synonyms will appear in ALL_SYNONYMS, else
> not.
>
> What type of synonyms are we dealing with here?
>
> Regards,
>
> - Kirti Deshpande
> Verizon Information Services
> http://www.superpages.com
>
> > -----Original Message-----
> > From: Joe Testa [SMTP:teci_at_the-testas.net]
> > Sent: Monday, August 06, 2001 8:26 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: 8.1.5/HP-UX 11/all_objects view
> >
> > ok unless i'm missing something here(which i could be, as i'm battling
> > installing a stupid printer under linux but thats another story).
> >
> > all_objects shows all objects you own or have access to.
> >
> > all_synonyms show all synonyms you own AND all public synonyms.
> >
> > so if you there is a public synonym on an object you dont have access to
> > it won't appear in all_objects but will appear in all_synonyms.
> >
> > Anyone care to straighten me out, or did i get it right :)
> >
> > joe
> > "Vergara, Michael (TEM)" wrote:
> > >
> > > Hi All!
> > >
> > > My question for today is 'when is an object supposed to be displayed
> > > in the ALL_OBJECTS view?'.
> > >
> > > I have a schema id which is a legacy id - left over from a previous
> > > version of our data warehouse. In this legacy schema are synonyms for
> > > the tables in the new schema. Grants and all are ok.
> > >
> > > When I log in as a user with the correct (I think) roles assigned, I
> > > want to do a select of ALL_OBJECTS and see what objects are still
> > > referenced in the legacy schema. However, these synonyms do not appear.
> > >
> > > They're in ALL_SYNONYMS, but not ALL_OBJECTS. I can query the synonyms
> > in
> > > a select statement so I know I have rights.
> > >
> > > Why do I not see these objects in ALL_OBJECTS?
> > >
> > > Thanx,
> > > Mike
> > >
> > > ---
> > >
> > ==========================================================================
> > =
> > > Michael P. Vergara | Don't worry about the world coming to an end
> > > Oracle DBA | today. It's already tomorrow in Australia.
> > > Guidant Corporation | - Charles Schulz
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Deshpande, Kirti
> INET: kirti.deshpande_at_verizon.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing)

-- 
Joe Testa  
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: teci_at_the-testas.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).