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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
