List:General Discussion« Previous MessageNext Message »
From:Gavin Towey Date:October 1 2010 5:25pm
Subject:RE: Object audit info
View as plain text  
Alternatively, if you only want to log modifications, then the binlog would suffice.

-----Original Message-----
From: vegivamp@stripped [mailto:vegivamp@stripped] On Behalf Of Johan De Meersman
Sent: Friday, October 01, 2010 6:21 AM
To: PRATIKSHA JAISWAL
Cc: mysql@stripped
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 <
pratikshadjayswal21@stripped> 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
Thread
Object audit infoPRATIKSHA JAISWAL1 Oct
  • Re: Object audit infoJohan De Meersman1 Oct
    • RE: Object audit infoGavin Towey1 Oct