A solution could be to
create a trigger and update two columns USER and LASTEDIT
to the current user and the current time.
Then check that the record's lastedit column and user column match the connected user and time within a few seconds.
as triggers will only fire when the update or insert succeeded.
I like to do this as a rudamentory audting system so if users
log in for example in oracle sqlplus I can see who changed the record and then go ask them why?
Could would look like:
NOT sure why the post says "generating numbers" though.
HTH.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement