I was wondering if anyone knew a way to store the name of the user who creates a record in a field in the table where the record is being added? Records get added to the database through a third party application and I want to store the user name that person is using to connect to the database in a specified field in the table that's being added to.
you can create a column with a default of "suser_sname()". You will still have to be responsible for updates though... an update Trigger can do the job.
I am not sure about all the details but that is basically what you need.
* Noel
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply