Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 04 Feb 2009 @ 14:27:07 GMT


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


Subj:   Re: Capture commands run in exec macro
 
From:   Rob Paller

DBQL should capture the individual statements run in the macro from a performance/workload standpoint. Teradata has long encouraged the use of macros as a means to extend security to users implicitly to allow them to manipulate objects they otherwise are not explicitly permitted to do otherwise.

If you need to track the actions taken within a macro you could always introduce and audit table. Then place the necessary statements within the macro to capture the USER executing the macro and the time which each step was completed.


HTH



     
  <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: 27 Dec 2016