#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    NRW/Germany
    Posts
    3
    Rep Power
    0

    Track currenctly logged in user in trigger


    Hi,

    I want to set a specific field on every update to the username currently logged in.
    Is there something like 'now' for the username or so?
    At the moment, we already set a timestamp in the trigger,
    but want to include the username, too, to
    keep track of who made changes to which tables, etc.

    thanks for any help,
    Daniel Albuschat
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Location
    Bucharest
    Posts
    72
    Rep Power
    11
    you can use:
    CURRENT_USER
    CURRENT_ROLE
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    NRW/Germany
    Posts
    3
    Rep Power
    0
    Thanks, that was exactly what I was looking for.

    cu, Daniel

IMN logo majestic logo threadwatch logo seochat tools logo