Alternatively, if you only want to log modifications, then the binlog would suffice.
-----Original Message----- From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De Meersman Sent: Friday, October 01, 2010 6:21 AM To: PRATIKSHA JAISWAL Cc: mysql@lists.mysql.com 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 < pratikshadjayswa...@gmail.com> wrote: > 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. > > > > Regards, > Pratiksha > -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org