albatross68
Programmer
We would like to log modifications (inserts/updates/deletes) on a table.
Because some application that access the database through ODBC connect using the same username and password we need to distinguish who did each modification using something other than the username.
We thought of using the user's IP address, but we can't figure out how to get this information in a trigger.
Any suggestions?
Suggestions of other information that we can use instead of the IP address are also wellcome.
Because some application that access the database through ODBC connect using the same username and password we need to distinguish who did each modification using something other than the username.
We thought of using the user's IP address, but we can't figure out how to get this information in a trigger.
Any suggestions?
Suggestions of other information that we can use instead of the IP address are also wellcome.
