From: Johan De Meersman (vegivamptuxera.be)
Date: Fri Oct 01 2010 - 08:21:27 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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 <
pratikshadjayswal21gmail.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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]