Alternatively, if you only want to log modifications, then the binlog would suffice.
From: vegivamp@stripped [mailto:vegivamp@stripped] On Behalf Of Johan De Meersman
Sent: Friday, October 01, 2010 6:21 AM
To: PRATIKSHA JAISWAL
Subject: Re: 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 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
This message contains confidential information and is intended only for the individual
named. If you are not the named addressee, you are notified that reviewing,
disseminating, disclosing, copying or distributing this e-mail is strictly prohibited.
Please notify the sender immediately by e-mail if you have received this e-mail by mistake
and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be
secure or error-free as information could be intercepted, corrupted, lost, destroyed,
arrive late or incomplete, or contain viruses. The sender therefore does not accept
liability for any loss or damage caused by viruses or errors or omissions in the contents
of this message, which arise as a result of e-mail transmission. [FriendFinder Networks,
Inc., 220 Humbolt court, Sunnyvale, CA 94089, USA, FriendFinder.com