From: paul@see.my.sig.com   
      
   Kristian  wrote:   
      
   > 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.   
      
      
   Try to look at the user_views table! BTW, this group is officially   
   dead. Post cdo.servers or cdo.misc instead.   
      
      
   Paul...   
      
      
   --   
      
   plinehan __at__ yahoo __dot__ __com__   
      
   XP Pro, SP 2,   
      
   Oracle, 9.2.0.1.0 (Enterprise Ed.)   
   Interbase 6.0.1.0;   
      
   When asking database related questions, please give other posters   
   some clues, like operating system, version of db being used and DDL.   
   The exact text and/or number of error messages is useful (!= "it didn't   
   work!").   
   Thanks.   
      
   Furthermore, as a courtesy to those who spend   
   time analysing and attempting to help, please   
   do not top post.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)