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 logging disk can keep up that shouldn't be more than 2 or 3
percent, I think.
On Fri, Oct 1, 2010 at 3:16 PM, 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 case they add/drop/delete any table/user/database/index.
> Please guide me how can I achieve that.
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel