Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 03 Aug 2005 @ 14:53:56 GMT

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

Subj:   Re: Collect Stats in a Procedure
From:   Srikanth Goli


Thanks for the clarification, however, the creator is not the immediate owner in my case, i.e, the user running the procedure is a regular user and the procedure and the table exists in the production database. This looks like a restriction that limits the usability of this feature. I believe it is normal that all the objects are owned by a restricted user (database) , and that regular users are not allowed to connect as the database owner. What is the workaround (is it dynamic SQL?).


  <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: 28 Jun 2020