Professional Web Applications Themes

Tracking changes for web app - Microsoft SQL / MS SQL Server

I am working with a web app that allows users to update/insert values. I would like to track changes via triggers, but I can't figure out how to determine the user who is making the change. All of the interaction between the web server & db server occurs under one account - is it possible for me to determine the user who is making the change based on their login. Any ideas?...

  1. #1

    Default Tracking changes for web app

    I am working with a web app that allows users to update/insert values. I
    would like to track changes via triggers, but I can't figure out how to
    determine the user who is making the change. All of the interaction between
    the web server & db server occurs under one account - is it possible for me
    to determine the user who is making the change based on their login. Any
    ideas?


    Adrian Walters Guest

  2. #2

    Default Re: Tracking changes for web app

    I thought about doing something similar to that, but figured my way was
    wrong... Thanks for pointing me in the right direction.

    "Andrea Worley" <k_ragehotmail.com> wrote in message
    news:027701c34654$73a97b30$a501280aphx.gbl...
    > Does your web app use Session variables or something to
    > track the user name? You could create a field in your
    > table to store the user. Then change the code so that
    > every web app update also changes the <user> field in that
    > table to the current Session user. Then the trigger can
    > grab that field from the inserted table in the trigger.
    >
    >
    > >-----Original Message-----
    > >I am working with a web app that allows users to
    > update/insert values. I
    > >would like to track changes via triggers, but I can't
    > figure out how to
    > >determine the user who is making the change. All of the
    > interaction between
    > >the web server & db server occurs under one account - is
    > it possible for me
    > >to determine the user who is making the change based on
    > their login. Any
    > >ideas?
    > >
    > >
    > >.
    > >

    Adrian Walters Guest

Similar Threads

  1. Ad Tracking
    By coldpopper in forum Macromedia Flash Ad Development
    Replies: 2
    Last Post: February 13th, 02:57 AM
  2. InDesign tracking vs. Quark tracking?
    By Mike Witherell in forum Adobe Indesign Macintosh
    Replies: 0
    Last Post: July 15th, 10:23 PM
  3. Tracking IP
    By Seth in forum ASP.NET Web Services
    Replies: 3
    Last Post: March 4th, 12:50 PM
  4. Tracking
    By Broose in forum Macromedia Director Basics
    Replies: 1
    Last Post: January 8th, 03:58 PM
  5. tracking a pid
    By mike in forum Sun Solaris
    Replies: 2
    Last Post: July 27th, 08:33 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139