1 Reply Latest reply on Jan 14, 2013 1:18 PM by Tridus

    how to pass asp.net user to oracle trigger

    Saad Nayef

      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)?

        • 1. Re: how to pass asp.net user to oracle trigger
          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