Post reply

Capturing Session Information

  • July 31, 2002 at 7:24 am

    #78550

    I have an application that connects to the database through an application id (e.g. Checking). The users of this application are making changes to the data and I want to track who is making the change and put it in an application log. The user is connected to the network by an id, but when using the application, SQL only sees the application ID. How can I pull the network id of the person making the change. I have looked at sys_user,suser_sname,suser_sid and none seem to be able to reach beyond SQL and get that information.

  • August 2, 2002 at 12:34 pm

    #433922

    Suser_Sname() will get your network name, however, if people are logging on from outside your network this will not work. What is your front-end application?

    Edward M. Sokolove


    Edward M. Sokolove

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply