RE: 8.1.5/HP-UX 11/all_objects view

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).