Object audit info

2010-10-01 Thread PRATIKSHA JAISWAL
Hi List, How can i audit every object of the database including database too. I will give you deep idea about it. Our environment having lots of application connected to database. We have created user specific to applications, which has admin rights. Now, i wanted to monitor/audit information in

Re: Object audit info

2010-10-01 Thread Johan De Meersman
Simply activate the full log (log directive in my.cnf) - this will provide you with logon, logoff and every command sent by every session. Keep in mind that this is a LOT of data; so you want to keep this on a separate set of spindles. It will also. obviously, make for some overhead, but if your

RE: Object audit info

2010-10-01 Thread Gavin Towey
: Object audit info Simply activate the full log (log directive in my.cnf) - this will provide you with logon, logoff and every command sent by every session. Keep in mind that this is a LOT of data; so you want to keep this on a separate set of spindles. It will also. obviously, make for some