Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 21 Mar 2002 @ 12:27:00 GMT


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


Subj:   Re: CRM Issues
 
From:   David Wellman

Word of caution...

I think you should be very careful about switching on access logging for a generic session which may be logged on for days. The PI of dbc.acclogtbl (which is where the results of access logging are stored) is Logondate and LogonTime. Not nice !

Having said that, Sharon's idea of looking for the latest logged entry will probably help you if you can have different sessions, each one executing fewer sql requests.

Today I don't think there's an awful lot that can be done about this. The logical place to change this is within the application middle tier (in this case CERES) to pass the 'real' username through to Teradata.

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)



     
  <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