Aug 20, 2007 · What is the difference between Access Logging and Query Loging? I know access logging can be enabled by running Dip script and query logging can be enabled by specifying "Begin Logging" on target object.But, what is the significacne of each of the two options?
TERADATA Access logging Access LoggingAccess Logging allows monitoring of data access requests in the system and log granted and/or denied requests. This is how you find out who is logging into Teradata and who has tried and failed.
They cannot create log rules on zone database objects. They cannot end zone-level logging rules that zone users created. Users with system-wide logging privileges are the DBC user and any non-zone users, including zone guests, who have ZONE OVERRIDE privilege and EXECUTE privilege on the DBC.AccLogRule macro.
Logs that can be purged manually or using Teradata Viewpoint. See “Deleting Old Log Data with Teradata Viewpoint” on page 195. Access Log (DBC.AccLogTbl) Data collected as defined in a BEGIN LOGGING statement, for each privilege check of an attempted user access of a database object. DBQ Logs: DBC.DBQLSummaryTbl
Nov 12, 2012 · Enabling and Disabling query logging in Teradata Database query logging (DBQL) is an optional feature in Teradata through which we can track processing behavior of database by logging user activity. User activity can be logged in various level namely object, sql text, steps, explain etc. one can also set limit to the length of query text to be logged.Author: Ajeet
Mar 11, 2016 · Modify it according to your requirements. begin query logging with objects, sql, usecount, utilityinfo LIMIT SQLTEXT=0 on all; begin query logging with objects, sql limit threshold = 5 elapsedsec and sqltext=0 on VIEWPOINT; THis command will only …