Archives of the TeradataForum
Message Posted: Wed, 03 Jan 2007 @ 11:23:58 GMT
"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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|