September 4, 2008 at 9:50 am
Hi Guys,
New here!
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.
Hope this makes sense.
September 4, 2008 at 11:08 am
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 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy