tables with no synonyms

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Wed, 07 Feb 2007 14:16:21 -0600
Message-ID: <BAY133-F243775A79D2815AE1300F979E0@phx.gbl>

I am using this query to find objects ( owned by User A) that have no private synonyms (for User B) created for other users:

select s.owner, s.synonym_name, s.table_owner, s.table_name, o.object_name, o.object_type
from dba_synonyms s, dba_objects o
where s.table_name = o.object_name
and o.owner='NAME'

How can this be improved upon?

we use a statement such as this to create private synonyms.

create synonym B.synonyn_name for A.object_name;

thanks.

---

Get in the mood for Valentine's Day. View photos, recipes and more on your Live.com page.
http://www.live.com/?addTemplate=ValentinesDay&ocid=T001MSN30A0701

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 07 2007 - 14:16:21 CST