SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
DB Audit Ques

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
DB Audit Ques
Author Message
nmcewan



Joined: 26 Mar 2007
Posts: 2

Post DB Audit Ques Reply with quote
Hi,

Does this Audit tool allow for automated export to a log file. For example, we need to have all audits for the last 24 hours exported to a log file that can be ftpd.

Also I created a sql server user with windows athentication domain/user and I can select to audit ALL(inserts, updates, deletes, all 20,000 tables)against this user. I log into sql server 2005 as this user and make changes to the db and DB Audit is not auditing those changes.

Can this app handle a db with 20,000 tables? It seems to seize up just trying to generate the triggers.
We will be using this to audit PeopleSoft.

thanks

Nicole
Tue Mar 27, 2007 11:21 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6502

Post Reply with quote
This can be easily done using DB Audit API. Basically a command line utility is available to export the data in a number of formats. It can be scheduled to run as often as needed using the Alert Center or any other available job scheduler.
Tue Mar 27, 2007 1:31 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.