8.1.5/HP-UX 11/all_objects view

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: Vergara, Michael (TEM)
  INET: mvergara_at_guidant.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).