Professional Web Applications Themes

Triggers and Users - Microsoft SQL / MS SQL Server

you can use function current_user or user_name() -- -Vishal "Peter" <co.uk> wrote in message news:070b01c34a07$42b572c0$gbl... ...

  1. #1

    Default Re: Triggers and Users

    you can use function current_user or user_name()

    --
    -Vishal
    "Peter" <co.uk> wrote in message
    news:070b01c34a07$42b572c0$gbl... 


    Vishal Guest

  2. #2

    Default Re: Triggers and Users

    You can use CURRENT_USER to return the database user name and
    SUSER_SNAME() to return the login name:

    SELECT CURRENT_USER, SUSER_SNAME()

    --
    Hope this helps.

    Dan Guzman
    SQL Server MVP

    -----------------------
    SQL FAQ links (courtesy Neil Pike):

    http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
    http://www.sqlserverfaq.com
    http://www.mssqlserver.com/faq
    -----------------------

    "Peter" <co.uk> wrote in message
    news:070b01c34a07$42b572c0$gbl... 


    Dan Guest

  3. #3

    Default Re: Triggers and Users

    You can use USER_NAME() or CURRENT_USER to get the user name, but maybe it
    is better to implement this functionality with SQL Server Profiler (comes
    with SQL Server) or the tools from www.lumigent.com. Both of these solutions
    will provide better performance and possibly more functionality than using a
    trigger.

    --
    Jacco Schalkwijk MCDBA, MCSD, MCSE
    Database Administrator
    Eurostop Ltd.


    "Peter" <co.uk> wrote in message
    news:070b01c34a07$42b572c0$gbl... 


    Jacco Guest

  4. #4

    Default Triggers and Users

    Thanks to everyone who answered, bol sure does not help
    sometimes.

    Anyway Jacco, the reason why we we are considering the
    triggers is that our profile does a lot, not just
    statement begin and ends, and we use lots of store
    procedures, so sometimes finding out who made a change to
    one piece of data is a problem.

    A solution other than modifying our profile is to have
    a "tracking trigger" within the tables to record who has
    changed things.

    Peter

     
    has 
    Peter Guest

  5. #5

    Default Re: Triggers and Users

    "Peter" <co.uk> wrote in message
    news:095801c34a0b$c7da8b30$gbl... 

    You may have already built your solution, but depending on how far along you
    are, you might want to look at OmniAudit which automatically builds and
    maintains the kind of triggers you are talking about.

    www.krell-software.com

    Steve Troxell
    Krell Software


    Steve Guest

Similar Threads

  1. License.Limit.Exceeded with 4x150 users licence andonly 300 real users
    By mm_patrick in forum Macromedia Flash Flashcom
    Replies: 6
    Last Post: November 18th, 01:30 AM
  2. License.Limit.Exceeded with 4x150 users licence and only300 real users
    By danielalamaison in forum Macromedia Flash Flashcom
    Replies: 8
    Last Post: November 14th, 08:04 PM
  3. Replies: 2
    Last Post: July 2nd, 01:48 PM
  4. triggers in DB2
    By Piotr in forum IBM DB2
    Replies: 2
    Last Post: August 27th, 03:37 PM
  5. Triggers
    By P. Saint-Jacques in forum IBM DB2
    Replies: 0
    Last Post: August 8th, 02:30 AM

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