List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:October 1 2010 1:21pm
Subject:Re: Object audit info
View as plain text  
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

Thread
Object audit infoPRATIKSHA JAISWAL1 Oct
  • Re: Object audit infoJohan De Meersman1 Oct
    • RE: Object audit infoGavin Towey1 Oct