1 Reply Latest reply: Jan 14, 2013 7:18 AM by Tridus RSS

    how to pass asp.net user to oracle trigger

    SaadNayef
      Hi,

      I'm creating a trigger (INSERT or UPDATE) on a table which is being manipulated by asp.net application. How to get web user (session user) from that trigger (web not OS_USER)?

      Saad,
        • 1. Re: how to pass asp.net user to oracle trigger
          Tridus
          In a normal web application, the user connects to the web server, and the web server has a special database account to connect to the database. The trigger isn't going to have the user on the web server unless you pass it in somehow.

          This link contains some suggestions on the "somehow" part: http://stackoverflow.com/questions/1880729/how-to-send-arbitrary-parameters-to-oracle-trigger