maria-developers team mailing list archive

[Oli Sennhauser <oli.sennhauser@xxxxxxxxxxxx>]

Hi all,

As suggested by Sergei we should discuss this here.

Copying the login trigger stuff to a place in the code where I thought 
it makes sense I have created a logout trigger. This gives the 
capability to track a session from its beginning to its end and collects 
all the data from each session.
With this capability we can start thinking about auditing of MySQL users 
like it is needed/wanted from big companies.

I am NOT a developer and I was just lucky that it worked out how I did 
it. So I am not of much help for an other approach as Sergei hinted in 
his comment.

Now: free to discuss...

http://www.fromdual.com/mysql-logon-and-logoff-trigger-for-auditing

Regards,
Oli

--

FromDual - Vendor independent and neutral MySQL consulting.
Website  http://www.fromdual.com/
Skype    fromdual
Jabber   fromdual@xxxxxxxxxxxxxx
Yahoo IM fromdual
Xing     https://www.xing.com/profile/Oliver_Sennhauser
LinkedIn http://ch.linkedin.com/in/shinguz
Twitter  http://twitter.com/shinguz