www.webdeveloper.com
+ Reply to Thread
Results 1 to 7 of 7
  1. 04-05-2006 07:41 AM #1
    JoeyD
    JoeyD is offline Registered User
    Join Date
    Oct 2005
    Posts
    59

    Getting username

    Is there a procedure or function I can use to know what user is running a trigger?
    Reply With Quote Reply With Quote
  2. 04-05-2006 12:56 PM #2
    chazzy's Avatar
    chazzy
    chazzy is offline Working class hero
    Join Date
    Aug 2005
    Location
    The Garden State
    Posts
    5,634
    the user being the database user, the application user, the server user...?
    Acceptable Use | SQL Forum FAQ | celery is tasteless | twitter

    celery is tasteless - currently needing some UI time
    Reply With Quote Reply With Quote
  3. 04-05-2006 02:03 PM #3
    JoeyD
    JoeyD is offline Registered User
    Join Date
    Oct 2005
    Posts
    59
    The user would be the database user. The one I am interested in is using Window Authentication.
    Reply With Quote Reply With Quote
  4. 04-05-2006 02:16 PM #4
    chazzy's Avatar
    chazzy
    chazzy is offline Working class hero
    Join Date
    Aug 2005
    Location
    The Garden State
    Posts
    5,634
    what dbms? in oracle just having the keyword "user" inside the procedure will capture it, then you can insert it somewhere or do something with it.
    Acceptable Use | SQL Forum FAQ | celery is tasteless | twitter

    celery is tasteless - currently needing some UI time
    Reply With Quote Reply With Quote
  5. 04-06-2006 05:57 AM #5
    JoeyD
    JoeyD is offline Registered User
    Join Date
    Oct 2005
    Posts
    59
    I am using Microsoft SQL 2000
    Reply With Quote Reply With Quote
  6. 04-07-2006 03:20 PM #6
    JoeyD
    JoeyD is offline Registered User
    Join Date
    Oct 2005
    Posts
    59
    Does anyone know if there is a function in the MSSQL 2000 that let's me know what user is modifing the table?
    Reply With Quote Reply With Quote
  7. 04-10-2006 07:54 AM #7
    JoeyD
    JoeyD is offline Registered User
    Join Date
    Oct 2005
    Posts
    59

    Wink

    The function I was looking for is this:

    DECLARE @Username varchar(50)
    Set @Username = User_Name()
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

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

Forum Rules

 HTML5 Development Center



Recent Articles