This discussion is archived
1 Reply Latest reply: Jan 14, 2013 5:18 AM by Tridus RSS

how to pass user to oracle trigger

SaadNayef Journeyer
Currently Being Moderated

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

  • 1. Re: how to pass user to oracle trigger
    Tridus Journeyer
    Currently Being Moderated
    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:


  • Correct Answers - 10 points
  • Helpful Answers - 5 points