Fw: tables with no synonyms

  • From: Nigel Thomas <nigel_cl_thomas@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 7 Feb 2007 12:56:01 -0800 (PST)

>How can this query to find objects ( owned by User A) that have no 
>private synonyms (for User B) be improved upon
Assuming I've understood the question correctly, you can just take the objects 
(including program units) that are owned by user A, and subtract (MINUS) the 
synonyms owned by B that reference those objects in A. 
select object_name, owner from dba_objects where owner = 'A'
select table_name,table_owner from dba_synonyms where owner = 'B'

Regards Nigel

Other related posts:

  • » Fw: tables with no synonyms