Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 09 Feb 2004 @ 18:22:21 GMT

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

Subj:   Re: DBC.AccessLog
From:   Rudel Simard

Does DBQL logs at the time? The SQLTEXT contains the same SQL than the accesslog table.

For a security policy, we need to log every complete SQL send to the Teradata. Does anybody have a idea how and where to keep it?

I know DBQL table can grown very quickly, but we can copy on tape perioditly. It's not a big deal to figure out how manage the content of those tables. The hard part is to have to COMPLETE SQL TEXT.


Rudel Simard
Régie de l'assurance-maladie du Québec
Administration des données

  <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