From: mcstockX@Xenquery   
      
   "matthias"  wrote in message   
   news:aae2699f.0409142339.3cb2f9ea@posting.google.com...   
   | assume:   
   |   
   | user a has the table tab_a   
   | user b has select-right on the table tab_a an creates the view view_b   
   |   
   |   create view view_b as   
   |   select * from a.tab_a;   
   |   
   | this works fine and b can see the content of the table tab_a.   
   |   
   | now b grants user c the select-right on his view view_b.   
   | but when c tries to look at the view   
   |   
   |   select * from b.view_b   
   |   
   | he gets an ora-01031: insufficient privileges! why? this even happens   
   | with select-rights on the table tab_a from user a! now he could create   
   | an own view on the table of user a or look directly on this table, but   
   | he still can't open the view of user b!   
   |   
   | what must be done that user c can look at the view view_b from user b?   
   |   
   | thanx   
   |   
   | matthias   
      
   b has rights, but notthe privilege to pass them on (which is what granting   
   on the view attempts to do)   
      
   this requires the GRANTE xxxx ... WITH GRANT OPTION syntax   
      
   ++ mcs   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)