Object audit info

--000e0cd30be8a6f9df04918dffd6
Content-Type: text/plain; charset=ISO-8859-1

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

--000e0cd30be8a6f9df04918dffd6--

Re: Object audit info

--001485ec070c7b58b204918e12f6
Content-Type: text/plain; charset=ISO-8859-1

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@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

--001485ec070c7b58b204918e12f6--

RE: Object audit info

Alternatively, if you only want to log modifications, then the binlog would=
suffice.

-----Original Message-----
From: vegivamp@gmail.com [mailto:vegivamp@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 provid=
e
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@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. No=
w,
> 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 th=
at reviewing, disseminating, disclosing, copying or distributing this e-mai=
l is strictly prohibited. Please notify the sender immediately by e-mail i=
f 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-fre=
e as information could be intercepted, corrupted, lost, destroyed, arrive l=
ate 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 transmis=
sion. [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=3Dgcdmg-mysql-2@m.gmane.o rg