Extracting the user performing the query

From: Shachaf Ben-Tzur (shachaf_at_xpert.com)
Date: 09/12/04

  • Next message: Dan Guzman: "Re: Execute permission denied" 
    Date: Sun, 12 Sep 2004 18:11:03 +0300

    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: Dan Guzman: "Re: Execute permission denied"