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