Re: Extracting the user performing the query

From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 09/12/04

  • Next message: Mike: "Broadcasting of server name" 
    Date: Sun, 12 Sep 2004 21:27:30 +0100

    Hi

    If you are not bothered about SELECT statements then the CREATE TRIGGER
    example in Books online as this has an example of simple auditing. Another
    way of auditing is to use a third party too such as those from Lumigent
    (Lumigent Log Explorer)
    http://www.lumigent.com/ or PI, http://www.logpi.com

    The Lumigent products will also show select statements.

    The SYSTEM_USER function should give you the current domain username or SQL
    Server user for the connection.

    John

    "Shachaf Ben-Tzur" <shachaf@xpert.com> wrote in message
    news:%23p9YWrNmEHA.416@TK2MSFTNGP10.phx.gbl...
    > Hi,
    >
    > I need to maintain a log of database users access - for that I need to
    > extract who is performing a given operation (SELECT, UPDATE, etc.).
    >
    > The application is two-tiers (windows forms) using windows authentication
    to
    > connect to the database. The two tier are located on different machines.
    >
    > Because the log will be maintained as a table itself - I think this is a
    > better way to extract the identity of the user performing the operation
    and
    > not transferring it from the client application.
    >
    > Is it possible?
    >
    > Tx,
    >
    > Shachaf
    >
    >

  • Next message: Mike: "Broadcasting of server name"