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
-- //www.freelists.org/webpage/oracle-l