InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 16:17:39 GMT20http://www.teradata.com/teradataforum/Topic11698-9-1.aspxHi tvrprice,what problem do you have in mind? You just get multiple rows within DBQL as you get multiple rows within AccessLog.But if the AccessLog is used for security reasons, i'd recommend staying with it. DBQL might miss some denials, but AccessLog won't.Just reduce the logging down to denials.DieterMon, 02 Jun 2008 08:12:34 GMTdnoethhttp://www.teradata.com/teradataforum/Topic11698-9-1.aspxHi, We have a report that reports on the number of Access Denials and the objects that are trying to be accessed in Access Logging (Result = 'D'). However, we would like to switch Access Logging off and use DBQL only .(we currently use both) Since the Result, SeqinHash columns isn't in DBQL how have others got around this problem. Many thankstvrpriceMon, 02 Jun 2008 07:30:48 GMTTVRPRICE