Re: upon retrieving the last insert id get the table name?
When you say
>who entered or updated a record besides audit logs.
do you mean an Application user, or database user?
Sounds to me like a job for your application to handle.
e.g. INSERT / UPDATE .....
Then store the details of the update, including (app) user to a logging table.
Or maybe you need a full audit trail, as shown in Peter Brawley's excellent website.
http://www.artfulsoftware.com/infotree/Transaction%20time%20validity%20in%20MySQL.pdf
Good luck,
Barry.
Subject
Written By
Posted
Re: upon retrieving the last insert id get the table name?
June 11, 2012 08:15PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.