add user name to field

  • 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.

  • 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