Home -> Usenet -> comp.databases.oracle -> List of all views created upon a specific table

List of all views created upon a specific table

From: Kristian <cristian_at_katamail.com>
Date: Mon, 13 Nov 2006 16:18:30 GMT
Message-ID: <qV06h.4565$mZ5.4074_at_tornado.fastwebnet.it> 





Let's say I have three database users:



    
  
  •   user_a
  
  •   user_b
  
  •   user_c






user_a has a table called table_a upon which user_b and user_c create
their corresponding views:



    
  
  •   user_a.table_a
  
  •   user_b.table_b (view upon table_a)
  
  •   user_c.table_c (view upon table_a)






I'd like to know if there's an easy way to get a list of all the views
in a database instance which were created upon a given owner/table.



This would help me to avoid dropping a database user who has tables that
other database users depend on.


-- 
Cristian


Received on Mon Nov 13 2006 - 17:18:30 CET












Original text of this message