IDA Auditing & temp tables

Posted in 2011

Topics: Security, Permissions & Auditing

MARK JALKIEWICZ — Mon, 31 Oct 2011 15:45:26 — source: IIUG Forums & Mailing Lists

We need to audit the creation and drops of regular tables, however an unwanted side effect is that auditing is picking up the creation and drops of temp tables. is there anyway to exclude temp tables ? 11.50.FC8 Thanks, Mark

↪ replying to MARK JALKIEWICZ

Fernando Nunes — Mon, 31 Oct 2011 18:40:11 — source: IIUG Forums & Mailing Lists

I believe the resulting audit log will have a tabid=0 for the temp tables. So the answer would be: You can filter the output, but not the output generation. Regards. On Mon, Oct 31, 2011 at 3:45 PM, MARK JALKIEWICZ < mark.jalkiewicz@verizon.net> wrote: > We need to audit the creation and drops of regular tables, however an > unwanted > side effect is that auditing is picking up the creation and drops of temp > tables. > > is there anyway to exclude temp tables ? > > 11.50.FC8 > > Thanks, > > Mark > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --0016e64f8fba72936f04b09c9136