Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 03 Jan 2007 @ 11:23:58 GMT

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

Subj:   Re: Username and last modified information for a particular table
From:   Fred W Pluebell

"LastAlter" means DDL (like ALTER TABLE or CREATE INDEX), not DML (like UPDATE or INSERT).

"LastAccessTimeStamp" can be activated via DBSControl option, but would include SELECT.

DBQL is activated by user or account (NOT by table), and OBJECT level data is optional.

If there are specific tables you wish to track, Access Logging might be a better fit than DBQL.

Neither DBQL nor AccessLog will tell you which rows or values were updated (unless you log the SQL and it happens to have all the relevant info specified as constants), just that some update or insert occurred.

  <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