Trigger to capture the username
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Trigger to capture the username

  1. #1
    Join Date
    Nov 2002
    Posts
    170

    Trigger to capture the username

    How can I capture the username that is updating a particular table ?
    I can write a update trigger on the table but how to get the username that is updating that table ??

    Is there any other way to capture this information ??

    Any help will be appreciated.

  2. #2
    Join Date
    Nov 2002
    Posts
    170
    Got the answer. Please close the thread.

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Just use the USER pseudo-variable....
    Code:
    SQL> select USER from dual;
    
    USER
    ------------------------------
    SYSTEM
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

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


Click Here to Expand Forum to Full Width