We have a few tables that I need to add auditing information for.
The idea is that we need to create an audit table that will track the following on the main table :
- any changes (updates,deletes, inserts) to the main table
The audit table should include the following information:
-- Who made the changes (username logged in) -- What type of change (insert,update,delete) -- Date of change including time. -- if update, which fields were updated. -- Query that was run.
I have tried to get similar examples on the net, however no luck so far that gives the specific information.
I know that this would probably be done using some triggers, however I am not sure on how to get the relevant information (i.e. user, query,etc...)
Any help would be appreciated.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Dec 06
Hal.sz S.ndor Re: audit trails
Dec 06, 2016; 11:34
Hal.sz S.ndor
Re: audit trails
Dec 07
machiel Re: audit trails
Dec 07, 2016; 08:26
machiel
Re: audit trails
Dec 07
Hal.sz S.ndor Re: audit trails
Dec 07, 2016; 08:56
Hal.sz S.ndor
Re: audit trails
Dec 07
Johan De Meersman Re: audit trails
Dec 07, 2016; 17:13
Johan De Meersman
Re: audit trails
Dec 08
machiel Re: audit trails
Dec 08, 2016; 09:39
machiel
Re: audit trails
Dec 08
Jesper Wisborg Krogh Re: audit trails
Dec 08, 2016; 18:47
Jesper Wisborg Krogh
Re: audit trails
May 30
Horimoto Yasuhiro [ANN] Mroonga 8.03 - Fast fulltext search for all languages on,MySQL
May 30, 2018; 15:15
Horimoto Yasuhiro
[ANN] Mroonga 8.03 - Fast fulltext search for all languages on,MySQL
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!