Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 31 Aug 2004 @ 13:50:43 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Owner does not have any with grant option access
From:   Czajkowski, Al (A.J.)

Chris was on the right track on this one. Sorry, I haven't had time to send an update before now.

Turns out, there was an identically named view in another database. That view was attempting to access a database without the appropriate grant with grant option in place. The java process, attempting to pull meta data about the view and underlying tables exposed the problem. As soon as the bad view in the other database was fixed, the java process ran successfully.

We are looking into a method of restricting the databases the java process looks at.


Al Czajkowski

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023